What is the deal with building a combo box on a form? The form has a record source.
When I build the combo box, I choose a query to base it on that specifically selects or organizes the data the way that I want.
It works. Now when I am formatting this combo box on the form, I notice it has no control source? Since the combo was based on a query
this makes no sense; but no control source at all? Would not the control source for the combo box be the original query the combo box was based on?
I could put in another control source, but that is does not seem a good idea.
I use the combo box wizard to create the combo box and as I said, I base it on a query not a table the query is more specific for my needs.
But when it is placed on the form and formatted, I notice that there I no control source.
When on the form what should the control source be?
The form of course has it own record source.
Any help appreciated. Thanks in advance.
Respectfully,
Lou Reed
I could use the table the query was based on, but that is not selective of the names that I want - hence the query.