Search results

Spike The only difference between the code sets is that you added a space between " and[. Is that what you meant to do? I tried it just in case and it made no difference in the execution (or lack of execution). Zoiboi

In the cells that give the error are there equations or external links?

Since the clients are unique (no dupes) and in first position you could also use a vlookup +VLOOKUP(E2,Sheet1!A:B,2,0) and it is a little more straightforward. Have fun!

Thanks for your quick response. The SQL portion of the code is what Access created from the base query. I only added the one line in red to get the text box data in. I'm not sure how to go to the format you suggest for the SQL because I need to keep the IIf statements that are embedded...

Hi Everyone I have a text box on a form that rolls up selections to form a criteria statement for a query. I tried calling it directly but got a "to complex to evaluate" error so I built the following VBA code to generate the query with a SQL statement. If no checkboxes are selected the...