I have two variables, first word and second word. How do I use these variables as part of criteria in an existing query, with an asterix eaither side of them? Setting the query criteria to Like [firstWord] & [secondword] doesn't work! Cheers.
many thanks for your help - however I've managed to do it by moving the value to a hifdden text box, which acts as the criteria in the query on my subform. Your code will be usefull in the future for me though so thanks again, cheers.