There is a slight problem with your solution in that you can't run a 'SELECT' style sql statement using the DoCmd.RunSql command, it will only let you perform an action query, ie update a field.
Is there perhaps a way to edit the sql code in an existing Access query, and then use the...
I need to produce a form that will allow the user to select which fields they would like to specify a criteria to search on.
For example, I may want to display all items by their category and/or within a price range.
I hope that makes some sense.
thanks in advance,
- Elliot.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.