Search results

Doc_man the query will be used to organise the list of businesses that the rep will need to call on in the next couple of weeks. The query will use the County or Counties required to pull together the list (hence multiple values). This will be done through Forms, so that the user compiling the...

Ok thanks for the suggestion Gasman, I'll have a look at that - didn't realise there was a difference. I have done all the F8 and F9 work, but nothing popping out at me.

Thanks 5 for the reply. Yes, I'm sure. I have the output on the form, and also when I run the code I have debug.print showing the value(s). I have this working fine with a single value committed to the textbox, but not when I have the string array. Yet the array works fine when I manually...

Hi all, it's a number of years since I was a member here before. Back using Access/VBA/SQL after a long absence. I'm having trouble with getting a global variable and/or a form field value to work as a criteria in a query. I think it's because the values are an array. I'm getting the multi...