Multiple queries vs. one query

I need help. Right now I use three queries with certain criteria in each one
to access three versions of the same format of form. It is kind of a
nuisance right now because if I make a change to the form. I have to change
all three forms as well and now I am using a subform in this as well, which
means I am going to have to be 3 copies as well because of the macro I am
using. What I would like to do is to use one query to access one form to
ease the nuisance of having to change all three forms. I have tried to paste
my criteria on 3 rows in the query, this works fine exept I get the perameter
messages. Is there any way to get away from having perameter messages, or
another way to get this done?

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...eries/200806/1

Where are these queries headed?

For many situations, you can provide a form with unbound controls where the
user can enter the critiera they wish to use. You then build a filter string
from the controls they used, and apply it as the Fitler for your form, or
the WhereCondition for OpenReport.

Here's a sample database to pull apart and see how this works:
Search form - Handle many optional criteria
at:
http://allenbrowne.com/ser-62.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"shannaj via AccessMonster.com" u36075@uwe wrote in message
news:86283c20e675f@uwe...
I need help. Right now I use three queries with certain criteria in each
one
to access three versions of the same format of form. It is kind of a
nuisance right now because if I make a change to the form. I have to
change
all three forms as well and now I am using a subform in this as well,
which
means I am going to have to be 3 copies as well because of the macro I am
using. What I would like to do is to use one query to access one form to
ease the nuisance of having to change all three forms. I have tried to
paste
my criteria on 3 rows in the query, this works fine exept I get the
perameter
messages. Is there any way to get away from having perameter messages, or
another way to get this done?

Thank you so much, it looks like this is exactly what I am looking for. One
of the problems I am finding is in my code for cmdFilter Click. My first
code is giving me a Compile error: Variable not defined for my strWhere =
strWhere. Is there something I am doing wrong?

Allen Browne wrote:
Where are these queries headed?

For many situations, you can provide a form with unbound controls where the
user can enter the critiera they wish to use. You then build a filter string
from the controls they used, and apply it as the Fitler for your form, or
the WhereCondition for OpenReport.

Here's a sample database to pull apart and see how this works:
Search form - Handle many optional criteria
at:
http://allenbrowne.com/ser-62.html

I need help. Right now I use three queries with certain criteria in each
one
[quoted text clipped - 11 lines]
messages. Is there any way to get away from having perameter messages, or
another way to get this done?

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...eries/200806/1

Nevermind, thank you so much, I figured out what I was doing wrong.

shannaj wrote:
Thank you so much, it looks like this is exactly what I am looking for. One
of the problems I am finding is in my code for cmdFilter Click. My first
code is giving me a Compile error: Variable not defined for my strWhere =
strWhere. Is there something I am doing wrong?

Where are these queries headed?

[quoted text clipped - 13 lines]
messages. Is there any way to get away from having perameter messages, or
another way to get this done?

--
Message posted via http://www.accessmonster.com