thomas goodwin <to*********@unc.edu> wrote in message
news:40********@news.unc.edu...
I have a query which asks for a parameter value to execute it.
To see the results I have to:
a) click on the query -- the "Enter Parameter Value" window pops up.
b) enter the parameter value
c) look at results in datasheet view
If I want to run the query again, I must
d) click to close the datasheet view
e) click on the query
f) enter the parameter value
g) look at results in datasheet view
Question: Is there a way to cut the number of steps in d) e) f) g) ?
thanks,
tom g
Much prefer doing this from a form.
Place a text box on a form (frmsearch). Call it say txtsearch.
in the query criteria put [Forms]![frmsearch]![txtsearch] - assuming you have
the names above.
by viewing query results in a form you have many more options as to how the data
is displayed.
So create a new form and use your query as it`s record source. the wizard will
do this for you.
On your search form add a command button to open your results form.
Depending on what you are seaching for using a combo box to select the criteria
works well.
You can also add 2 text boxes (formated to date) on your search form which
allows you to search between 2 dates
You would need something like this in the query date field criteria - Between
[Forms]![frmsearch]![firstdate] And [Forms]![frmsearch]![lastdate]
HTH
David B