Query Based On Combos

[shoelesscraig]

Tried searching for this, but didn't find what I was looking for...

I have a table, just call it "Table1". It has many fields, but one of them (called "Field1") has several possible entries that could be in it...or it could be blank depending on the particular record. The text that was entered into this field was done by a form that limited the possible entries to a few...for example, "Option 1", "Option 2" and "Option 3".

Here's my dilemma. I have a form where by I would like to run a query ("Query1"). Also on that form is a combo box where the user can select "Option 1", "Option 2" or "Option 3". I would like it so that if the user selects "Option 2" and then runs the query, the query will return every record from Table1 where Field1 = "Option2". Obviously if they select "Option 1", I want all records where that is the case. I believe I can figure this out no problem....BUT...I would like for the query to return ALL entries if the user leaves that combo box blank...as in, makes no selection at all.



Is there a way to do this?

[shoelesscraig]

I've tried several options, and can get it to return what I want IF I select something from the combobox...but when I leave it blank, the query returns nothing at all. I assume leaving it blank is NOT the same as really being blank, but I'm not sure what it's doing!

[andy49]

Can we see the query you are using please


Sent from my iPhone using Tapatalk