A form has several combo boxes. The user wants two of these to be combined into one combo.
Each of the two fields presently has a distinct query as a Row Source:
PhaseCode query accesses Job, Company, Vendor to return the PhaseCode.
CostCode query accesses the same 3 fields plus PhaseCode.
Making a single query is no problem (I think) but how do I get the separate elements into the cols of the proper column.
And what do I put into Control Source, which now obviously contains only a single field name from a table?
Moreover, these are actually input fields. Can that be handled by a multi-column combo? (I don't think so - and if the answer is No, then the whole thing is a bad idea to be discarded.)
And what other problems are there with this idea?