WEB LIFE
GADGETS
SOFTWARE
STYLE
DOWNLOADS
SHOPPING
TECH SUPPORT

Tom's HardwareTom's IT Pro

Computing.Net

MS Access 2003 Parameter Query with forms

Tags:
Microsoft Access 2003 (full product)
Access
default
Score
0
Vote Up
April 19, 2010 at 06:53:58 Pacific
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


Reply ↓  Report •


#1
Vote Down
Score
2
Vote Up
April 19, 2010 at 13:46:12 Pacific

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


Reply ↓  Report •
Reply to Message Icon Start New Discussion
Related Posts
See More ↓

« Load data to database for... sql join queries »

This post is quite old and has been locked from receiving new replies. Please create a new posting instead.

Ask the Community!
Describe your Problem
Example: Hard Drive Not Detected on My PC