Lookup Values

[jbarrum]

Can someon tell me if it is possible in Access to create lookup to lookup values based on a "row" in a table intead of a "column" I want the user to select the first value from a column in a table "A" and then have the second lookup pull from two fields in the same row from that table (Table "A")



Is this possible?

[RuralGuy]

That sounds like Cascading ComboBoxes to me.

[jbarrum]

It appears that this will work if the data I want to look up is in different rows but I was trying to look up data that is in the same row. The best example I can give would be if the user hits the drop down & selects the employee and then selects the second drop down and chooses between his address or his phone number. (with address and phone_num being in the same row)?

[RuralGuy]

Without some other value or control to select the column I do not know how to get that.

[jbarrum]

Yes, that is what I thought. I need to see if I can find a way to store the data I want to lookup on different rows. Otherwise, I will just have to forgo what I was trying to do. Thanks for the quick reply.

[RuralGuy]

Unless you use different ComboBoxes for the various columns. You can select any column of data in the RowSource of a ComboBox since it has a Column() property.

[jbarrum]

Good idea, I will try and work it that way. Thanks