Use form input to modify queries

[laxster]

I have a database setup which uses forms to simplify things for people who need to run reports and enter data. I simply use a form to accomplish this, with the finished data outputting to an Excel spreadsheet. I am running into an issue in which I want to create a criteria using a text input box that will modify queries to filter out days.

What should happen is that on this form, the person should be able to enter a date in the text box, and that text box then will modify all the dates on the queries prior to the information spitting out in Excel. Somehow I can't see how to do this. Is it possible? If so, how?

Any advice is much appreciated!

 

[boblarson]

I have a database setup which uses forms to simplify things for people who need to run reports and enter data. I simply use a form to accomplish this, with the finished data outputting to an Excel spreadsheet. I am running into an issue in which I want to create a criteria using a text input box that will modify queries to filter out days.

What should happen is that on this form, the person should be able to enter a date in the text box, and that text box then will modify all the dates on the queries prior to the information spitting out in Excel. Somehow I can't see how to do this. Is it possible? If so, how?

Any advice is much appreciated!

1. The form remains open.

2. You set the CRITERIA of the queries to reference the FORM and text box by putting something like this in the CRITERIA line of the Query by Example grid:

[Forms]![YourFormNameHere]![YourControlNameHere]