We help IT Professionals succeed at work.

New podcast episode! Our very own Community Manager, Rob Jurd, gives his insight on the value of an online community. Listen Now!

x

ACCESS 2000 - Combo multi-column question

ljcor
ljcor asked
on
370 Views
Last Modified: 2012-06-21
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?
Comment
Watch Question

Infotrakker Software
CERTIFIED EXPERT
Most Valuable Expert 2012
Top Expert 2014
Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION

Author

Commented:
Thanks, guys.  

While I was waiting for your response to this question I had already decided to have an early Monday morning flash for him:  It's just too much trouble for too little money.  I could explain more but now we are all wasting our time.

Jack
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.