Multiple parameter query

J

JoeA2006

I need a form to allow the user to drill down to records using a multiple
parameter query. In the columns criteria I have something like this
[Forms]![Form3].[Form]![Text3].

I will have three parameters entered from the form Date , Mfg and part number
How do I allow the user to only enter Date and Mfg and part number leave
the part number text box blank but return all records for the date and mfg?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Crating User Form to Add Names 1
Space at end of multi page list to accommodate new entries 1
Copy previous record into form field 0
Multiple Parameter Crosstab query filter by form 1
Sorting Multiple Tables 1
Parameter Query multiple criteria help 6
Adding data to MS Access from csv file 0
creating a query from two tables 2

Top