Changing Criteria in a query using a form

[jrock76]

Hello,

I am working on a database which has many queries that count different statistics of clients (race,gender,ect) during specific date ranges. I would like to set up a form that you could go in and enter a date range into a text box and it would update the criteria (date range) for each of the queries. How would this be possible? I have looked at some past threads similar to this but they didn't help.

Any help will be greatly appreciated.

 

[Brianwarnock]

When obtaining criteria from a form the criteria references the form/textbox like so forms!formname!textboxname so it might be

Between Forms![Dateform]![startdate] And Forms![Dateform]![enddate]

Brian

 

[Brianwarnock]

A quick serach came up with this thread

http://www.access-programmers.co.uk/forums/showthread.php?t=108999&highlight=form+queries

Brian

 

[jrock76]

Brian,

Thank you for responding. I tried what you said and I didn't get any values. It seems like all the threads are saying to do it the same way you did.I don't know what the problem is

 

[jrock76]

I got it to work. Thank you very much for the help.

 

[Brianwarnock]

I got it to work. Thank you very much for the help.

Thats great, thanks for letting me know it saves me overworking the old grey matter

brian