Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

query filters from forms

Status
Not open for further replies.

StarryEyed

IS-IT--Management
Oct 18, 2000
3
0
0
US
I want to run a macro two of whose queries use a begining date and ending date as
a filter. I want to build a form in which the user can enter the dates before executing the macro. How do I tie the date parms in the queries to the form. I tried the following
and it did not work: >=[Form]![ProjectForm]![BeginingDate] and <= [Form]![ProjectForm]![EndingDate].
 
this code place in the queries critera section should work

between Forms![ProjectForm]![BeginingDate] and Forms![ProjectForm]![EndingDate]

Use the expression builder to prevent typo errors in the formula I believe beginningdate may be correct spelling of the field
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top