Access prompts for variable value repeatedly

[MarcK]

I have a query which asks the user to enter a date. This date is then passed as an argument to a simple vb function, along with a date from a table, which returns a value representing the comparison of the two dates.

The query works fine, but Access asks me to enter the date two or sometimes three times before returning the results of the query.

I presume this is a standard problem with a standard answer? If desired, I will be happy to post a simplified form of the query and the function.

Thank you very much for any help.

 

[JJOHNS]

I think I've done the same thing. I put a date on the form that created the report. Then I made another form, a PrintForm, which prompts for the date of the report to print. The two are compared and I get a print of the correct report. Here's how I did it:

In the design view of my query, I included the date of the main form. On the criteria line, I put:

[Forms]![PrintForm]![txtPromptDate]

Now, as long as I use the PrintForm to print the report, I don't get prompted for the dates. However, if I go into Reports and preview reports there, I'll still be prompted, because from there, the report doesn't know what date to show.

 

[Databaseguy]

If you sort on a field, and change the name of the query, Access will behave that way. Tyrone Lumley
augerinn@gte.net

http://server105.hypermart.net/databaseguy

 

[MarcK]

Thank you for the solution.

Is there any advantage to this behavior by Access?

 

[Databaseguy]

>>Is there any advantage to this behavior by Access?<<

Yeah, keeping you sharp

Tyrone Lumley
augerinn@gte.net

http://server105.hypermart.net/databaseguy