Ok, I have created a list box on my form where people can choose all the towns they are interested in seeing data from. Then I take all the towns and create a string expression to send to my query - storing it all in a text box. For example, say they choose... Chelsea, Monkton, Addison... in the list box, they click on a command button and in the text box this is expression that shows up... "Chelsea" or "Monkton" or "Addison" - Then they click to view the report for with the informatin for these towns. So, in the query for the report in the TOWN field I would put the criteria as ... forms!frmTowns!Text1 - The problem is that Access inserts it's own Quotes and it is therefore throwing off my string. I just want to STOP access from inputting it's own quotes. And just read my string exactly as it is.
Can anyone suggest anything???
Thanks
Can anyone suggest anything???
Thanks