Show All in combo box

[hunter122976]

I'm fairly new to access. I've just been learning as I go, so bear with me.

I have a form that opens a query. In form view, I have a combo box, that has a list of customers in it. All works fine for just selecting one customer, but I'd like to have an option to show all customers, so when the form opens the query, it's possible for me to see them all.

Is this possible?



Thanks in advance

[pbaldy]

How about this:

http://www.theaccessweb.com/forms/frm0043.htm

with this

http://www.theaccessweb.com/queries/qry0001.htm

[hunter122976]

Thanks, that worked. Curious though...Why does the "All" disappear when you click on it?

[pbaldy]

No problem. Not sure why that happens, though it seems like I've heard about it before. I haven't used that method, I just have users leave blank for all.