Combo Boxes...

[tlynn]

Let it be known that I am realitively new to the world of Access and all the good things that come with it. I am currently working on a Combo box that when the name is selected...I need the info associated with that name to change in the form I created...an example follows:

Name : Combo Box "name"
Home Phone:Home phone
Cell Phone:Cell phone
Title:Job Title
Shift: Shift worked


Vague at best I know...but some kind of direction would be greatly appreciated. I will continue to persue the additional threads here. T

Thank you in advance.

 

[VicRauch]

Really to help it would be nice to know more about the overall need and form design, but here is some quick help.

The combo box is sourced by a query, I'm assuming. And, I'm assuming that query is against a table that has all this information in it. That is, Name, Home Phone, Cell Phone, Job Title, and Shift Worked. So, include all that information in the query, and for the sake of clarity here, in the order just listed. The combo box has a property named "Column" which will allow access to all this extra data. The first column in the query will be .Column(0), the 2nd column in the query will be .Column(1) as a property of the combo box. I think you can get the picture here.

So, in the AfterUpdate event of the combo box, set you other fields equal to the appropriate column from the combo box.

HTH,

 

[tlynn]

Thanks so much, I will give this a try!