How do you add an "*" or all line to combo box?

[WhiteZiggy]

Question,

I have a combo box that gets its data from a table/query.

How can I add a value that is not in the table or query? I want to have a value at the top such as a "*" or the word "All".

They are searching by 2-3 criterias. They dont have to select a region for instance. Thus they would want all regions.

Any ideas as to how to get the value "*" in the combo box along with the list that is there?

Thanks,
Jeremy

 

[mph1]

To add all to the combo box:

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

To add an item not on the list:

http://www.mvps.org/access/forms/frm0015.htm

Hope this is what you were referring to!!

An investment in knowledge always pays the best dividends.
by Benjamin Franklin
Autonumber Description - FAQ702-5106