Form-Based Parameter Query

  • Thread starter Thread starter Scott
  • Start date Start date
S

Scott

Trying to build a form-based query which allows the user
to search for records using values from five record
fields. The fields I'm searching against include the
primary key (as a text box), and four combo boxes that
display looked up values.

I've set up the form to run against a query, and have
entered the parameters in the query design window (as well
as the query parameters table). In each case, I'm
referencing the form name and the controls located on the
form using the [Forms]![FormName]![ControlName]syntax.

I've been trying to tweak this query all day, but still
can't get it to return any results, no matter which
criteria I select in the form.

Any ideas?

Scott
 
Can you post your SQL? And have you considered just teaching the users how
to use the built-in Filter by form technique?
 
You can enter the following in the qbe pane for each of
the fields that need to be searched on. This way, the
user gets a result based on only the fields used. All
records will be produced based on each parameter without
a response. If no response is entered in any of the
fields, the query will produce all records.

You can include all parameters on the same row or on
separate rows as necessary for the "and" and "or"
responses.

Like [Please Specifiy a Specific Location] & "*"
 
Back
Top