MS Access 2003 Parameter Query with forms

Microsoft Access 2003 (full product)
April 19, 2010 at 06:53:58
Specs: Windows XP
I have been trying to get my form which has date fields to fire up when i am prompted for parameters in a parameter query. my form is called frmDateRangeSelecter and the syntax i use is between Forms![frmDateRangeSelecter]![StartDate] and Forms![frmDateRangeSelecter]![EndDate] . when i run the query the form dosnt come up and the default prompt is

" Enter Parameter Value : Forms![frmDateRangeSelecter]![StartDate]"

can you please assist

See More: MS Access 2003 Parameter Query with forms

Report •

April 19, 2010 at 13:46:12
You can use the code:
DoCmd.OpenForm "frmDateRangeSelecter", acNormal

Depending on what you are doing with the query would determine where to put the code. For example, if you are using the query in a report, you could put that code in the report’s On Open event

Report •
Related Solutions

Ask Question