Editing parameter box to ask all criteria at once.

[poolz]

Editing parameter box to ask all criteria at once.

How do you edit a parameter box to ask all the set criteria at once, instead of one at a time. Help, asap please! ( Anyone who replies please put instructions very clearly and easy to follow)

thanks

 

[jatfill]

base you parameter limits on a form instead of a parameter inquiry, then you can fill out all of the fields on the form and run the query...
the limit would be

=Forms![formname]![controlname]

 

[rjparker1]

A form would be much easier. Create your query. Then save it, with just regular values. Then, you can create a form, and use the query as your entry records. The form you create, uses unbound fields. Then you can have the query grab the value of each of the fields.

For instance. Name, Address, Phone.

Query: contact.name, contact.address, contact.phone.

Form: Name [Bubba]
Address [USA]
Phone [1234567]

Your query will then use bubba, usa, 1234567.

You have to do some reading on how to get the query to set data from a form, but its like you have a form called Lookup.

In your query, you have Forms!Lookup!name.value (can't rmember the exact syntax) but that's why you have to read about his part.. Then, you open your form, fill in the blanks.. and run the query. I believe that will work.

Forms! (Name of the object type)
Lookup (Name of the form)
name (the actual field on the form - it can be called anything you like, normally by default its a text box named textbox)
value (is the actual value that you fill in the box with, such as Bubba, USA, and 1234567).

I hope that's pretty clear, this is pretty easy one you follow the examples in a good Access book. I recommend: Mastering Access 2002. Good luck.