run form with filtered criteria

[odun]

Hello all,

I have looked through the forum, found some things, but not sure if they help with what I need specifically. I tried looking at the microsoft website, but can't really follow some of the things they have there.

On clicking a form (called Manager), I would like a list of some fields from a query (called queryMgr) to pop up, so that I can put in the criteria as I would if I just used the query, and then submit or run, and the form gives the filtered results. I don't want users to open the query and put in their criteria, I just want them to go to the form directly

When I click the form, I want the following to pop up at the same time so I can fill in the criteria:

Date
Vendor Number
Invoice Number
Check Received (this is a Yes or No field)

and then when I click submit or enter, the form gives me say 5 records that match this criteria.

Thanks a lot!!!

 

[odun]

Hello all,

I found a post that I could use something like this in my query:

[Forms]![Manager]![Vendor] or Forms![Manager]![Vendor] Is Null

My query has about 15 fiields, but I have about 5 fields that I would like to run criteria on. So, I copied and pasted the above into these fields, changing the field name e.g. changed Vendor to Date.

And then I created a button in the form liked to a macro that runs the query.

The problem is, on opening the form, I get a Name# error on each of the fields that have I put a filter on.

Also, is there a way that I don't need to even open the form, just doubleclicking it will bring up a text box with all the criteria to be checked

What happens if I don't fill in one of the criteria, would it only return results when that field is blank?

Please help,urgent.

Thanks again.