Date Form

[dhoover via AccessMonster.com]

I've created several Queries with a paramter [Date]. In the criteria line of
this field, I put "Is Not Null And Between [Forms]![Reporting Dialog]!
[MonthBeginning] And [Forms]![Reporting Dialog]![MonthEnding]" so that it
will open a form called Reporting Dialog that already has the dates plugged
in and all the user has to do is click ok.


This works just fine for some queries, but for others, it prompts the user to
actually input the parameter. Why would this only work with some queries?

 

[Douglas J. Steele]

Is the form open when you're prompted? (Access won't open it for you if it
isn't).

If it is open, might you have mistyped the form name or the control names?

 

[dhoover via AccessMonster.com]

No the form isn't open prior to running the queries in any of the cases.
Sometimes the form automatially opens and sometimes it doesn't when the query
is ran.

Is the form open when you're prompted? (Access won't open it for you if it
isn't).

If it is open, might you have mistyped the form name or the control names?

I've created several Queries with a paramter [Date]. In the criteria line
of

[quoted text clipped - 7 lines]

to
actually input the parameter. Why would this only work with some queries?

 

[John Vinson]

No the form isn't open prior to running the queries in any of the cases.
Sometimes the form automatially opens and sometimes it doesn't when the query
is ran.

Something else is opening the form (or making it visible) then,
because the query will NOT do so.

John W. Vinson[MVP]

 

[fredg]

No the form isn't open prior to running the queries in any of the cases.
Sometimes the form automatially opens and sometimes it doesn't when the query
is ran.

Is the form open when you're prompted? (Access won't open it for you if it
isn't).

If it is open, might you have mistyped the form name or the control names?

I've created several Queries with a paramter [Date]. In the criteria line
of

[quoted text clipped - 7 lines]

to
actually input the parameter. Why would this only work with some queries?

You are mistaken about the query opening the form.
Queries do not open forms! Queries do not open reports. Queries do not
open anything. Queries display or manipulate or alter data.

Perhaps your query is used as the record source for a report.
Report's can (if you have coded it to do so) open a form to be used as
parameter entry. Check the report's Open event.

 

[dhoover via AccessMonster.com]

hmm, I'm have to dig to see what would be causing that. Thanks!