Add criteria to an existing query via VBA

[Metrazal]

I'm having some difficulty adding a criteria to a field in my query via a VBA macro. My aim is to insert a date range criteria into the field "DATE: REC_DATE" in a query labeled "Usage -1". Unfortunately, I'm having some issues in doing so. I currently have the criteria being saved in a field on an imported table but I'm unsure of the best way to set this criteria for this field. Following is where I've gotten so far:

Please Login or Register  to view this content.

Any help would be appreciated.


Thanks

Met

[ranman256]

use a form, with txtStartDAte and txtEndDate.
so you dont have to keep entering data over & over.

then the query: qsMyQuery is:
select * from table where [DateField] between forms!fMyForm!txtStartDate and forms!fMyForm!txtEndDate

so all you do is call:
docmd.openquery "qsMyQuery"

[Metrazal]

Thanks for your help.