Pass Combo box info to query

[Remillard]

I'm a fairly new user to Access so don't have a grasp of what, I'm sure, are some pretty basic query constructs. Here's what I have and am trying to do.

- Table with staff information including if they've received training (yes/no box) and what city they work in.
- Form with combo box to choose which staff in which city to display their training status.
- Query displays results based on city choice

This works fine when a specific city is chosen from the combo box but I would like an "ALL" choice in the combo box to display all staff from all cities. I thought it might be a second query criteria in the city field something like: If [Forms]![Expiry]![City] = "All" then.... and I get lost at that point. LOL!



Thanks in advance!

[pbaldy]

One way would be to combine these two:

http://access.mvps.org/access/forms/frm0043.htm

http://access.mvps.org/access/queries/qry0001.htm

[Remillard]

pbaldy, again you come to my aid. I'm very appreciative of the support.
Interestingly, in the first link you gave was this query code:
[Forms]![myForm]![myControl] OR [Forms]![myForm]![myControl] Is Null

It occurred to me, why wouldn't "All' work instead of "Null". Well sure enough, it does! Cleaner than having to combine.
Thanks much for pointing me in the right direction. Again, I have some scripting knowledge (powershell) but I know next to nothing about the language and structure of Access and VBA.
I've got a few more queries to create so I have a feeling I'll be making a new post in this area shortly!

[pbaldy]

Happy to help!