Apologies if this has been answered already - I have spent over an hour looking at several options, but cannot find the one I need!
I have an unbound combo box on a form. The rowsource is data from a table.
I am displaying "choose..." when the form is first opened (variable).
I would also like to be able to have at the top of my list the option to select "ALL".
The idea is that a form will be opened based on the combo selection - if "all" selected - open form with all records, otherwise filter to selected item.
Does anyone understand what I am looking for? Any help will be appreciated! NKA
The answer's always easy - if you know it! ;-)
I have an unbound combo box on a form. The rowsource is data from a table.
I am displaying "choose..." when the form is first opened (variable).
I would also like to be able to have at the top of my list the option to select "ALL".
The idea is that a form will be opened based on the combo selection - if "all" selected - open form with all records, otherwise filter to selected item.
Does anyone understand what I am looking for? Any help will be appreciated! NKA
The answer's always easy - if you know it! ;-)