Modify a query at run-time

[dogdays]

Access 2003 win 7 32bit
I have a query:

SELECT * FROM tblName

At run time I would like to add a WHERE clause prior to execution. How would I do that.

tia Jack

 

[alansidman]

You could create a search form and enter the where data (criteria) in the search form and then execute the query.

Look at this video for an example.

http://www.datapigtechnologies.com/flashfiles/searchform.html

Alan

 

[dogdays]

Alan:
Thank you, good advice.

Jack