View Full Version : Run Query through a form interface


umdloti
10-24-2000, 07:23 AM
I have a query with the the following criteria.

Between[Start Date] and [End Date] for a field Period.
[Type] for a field Container.

Can I represent these on a form so that I can
key them all in and see them on a form before submitting the query. ie so that I can make changes if I can see that 1 of the criteria was keyed in incorrectly.

lamha
10-24-2000, 10:30 AM
Create a form called frmCriteria. Make 3 unbound text boxes on this form: txtStartDate,txtEndDate, and txtType.
In your query's criteria row, under your Date field, type:
Between [Forms]![frmCriteria]![txtStartDate] And [Forms]![frmCriteria]![txtEndDate]
Under Type field, type:
[Forms]![frmCriteria]![txtType]
Then Make a command button to run the query on this frmCriteria.