Combo List Bound Fields

[CarolCook]

Hi:
I have a client that wants to have two columns in a table -both of which values are going to come from another table. The table of values is simple: Job # and Job Name. The challenge is that the client wants to populate two separate fields - first, picking the job number from a combo list - that's easy - the drop down list shows the number and name and the field will prefill with the job number. I'm stumped on the second part - the client wants another column to prefill with the description that goes with the bound job number from the previous field. (Access 2000). Any ideas?
Thanks in advance,
Carol

 

[PHV]

Have a look at the Column property and the AfterUpdate event of the ComboBox object.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[CarolCook]

This is a table, not a form though. My challenge is to limit the number of queries so that updates can be done on the end-result forms. Is there no way to do this on the lookup tab of a table?

 

[PHV]

Have a look here:

http://r937.com/relational.html

http://www.mvps.org/access/tencommandments.htm

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[CarolCook]

First PH, let me thank you for answering so many of my hard questions over the last several months. You have selflessly donated your time and I am truly grateful.

Having said that - here's my new challenge. One field on my table is still driven by a combo box and that in turn is driven by a union query on two tables. Needs to be two because one table is maintained in an outside software package and is only linked to the Access DB. The other table contains 'additional values' which the people who maintain the 'outside' package are not going to maintain.

The table works extremely well. In the form, the user can pick a job off of what looks like a single list. However, when designing the form I now need to pull the description from the appropriate table (either the linked one or the addition values one) - how do I incorporate a union query into the form?