Parameter Querie

[omar]

Again, thanks very much for your suggestions and comments,
you all have been extremely instrumental in my ability to
understand access.

I have a parameter querie setup using the "Between [start
date] and [end date] syntax. I have a print menu that I
use to print the report from this querie. When I try to
print, the "start" and "end" date boxes pop up. What I
would like to do is be able to type in these dates in my
form and have access use these dates to run the querie
instead of prompting the user for this information. Thanks

OMAR

 

[Joan Wild]

Modify the query to refer to the controls on your form. For example

Between Forms!frmCriteria!txtStart And Forms!frmCriteria!txtEnd

Change frmCriteria to the name of your form and txtStart and txtEnd to the
names of the form controls.

 

[Van T. Dinh]

(already answered in "microsoft.public.access")

Please do NOT multi-post the same question in various newsgroups. If you
think it is necessary for your question to appear in more than 1 newsgroup
(it is rarely necessary for a well-phrased question in an appropriate
newsgroup), use cross-posting (sending ONE post with up to 3 relevant
newsgroup addresses)

Please see the Netiquette for correct use of newsgroups:

http://www.mvps.org/access/netiquette.htm