parameter query

[hugz via AccessMonster.com]

I have one parameter query source on one of my listbox that requires to enter
the beginning and ending date... Everytime i switched the form to its design
view and go back to form view the parameter query in that list is running
requiring me to enter the beginning and ending dates before i could enter to
form view..

How can i resolve this problem..?

Pls help me..

tnx...

 

[Duane Hookom]

IMHO the solution is to never use parameter prompt queries. Always use values
from controls on forms.

 

[Joey]

I have often seen that we should switch to controls on forms but I was under
the impression that if the report is based on a query than it can't be done
this way. I've tried several items and have had no luck, is there a way to
do it if you're using a query to aggregate your data?

 

[Duane Hookom]

You should always be able to replace a parameter prompt with a reference to a
control value of an open form. If this doesn't work for you, come back with
more information.

 

[Joey]

Thanks, I thought it would be more appropriate to begin my own thread, since
hugz problem is not he quite the same as mine. Can you please see the post
called "Date Range for a report" that I just posted.

Thanks