Prompt for Condition in Parameter Query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is it possible to have the user prompted not only for the value but for the condition in a parameter query
for example
I want it to be possible for the user to sa
"give me all records that match "A500" in field
or "give me all records EXCEPT those with "A500" in field
without having to create a separate prompt (this would confuse some)

Any ideas
 
You could build a search form with two fields. One unbound field to contain
the string, and one drop-down list to contain the valid fields from which
they could select. You would also need a radio button or drop down to allow
them to select include or exclude.

You could then build code to construct a filter or sql statement and return
the results in a subform on that same search form, or have it open a
separate form and apply the filter or sql.

Rick B


Is it possible to have the user prompted not only for the value but for the
condition in a parameter query?
for example:
I want it to be possible for the user to say
"give me all records that match "A500" in field X
or "give me all records EXCEPT those with "A500" in field X
without having to create a separate prompt (this would confuse some).

Any ideas?
 
Back
Top