Question on combo box and multiple data fields 1

[mikeg8]

Background...
MS Access 2000
Table tbl-Specimens
Form frm-SpecimenView

In tbl-Specimens, I have 2 fields (amongst others!) which I'm having trouble with. One is called 'code' and is obtained from a lookup which get's its data from a separate table. The other is called UNS.

The combo box for 'code' is configured to show 2 columns, one called code and one called UNS. The 'code' item (unique) is stored in the field 'code' in the table. What I want to do is store the associated 'UNS' item in the field UNS in the table at the same time. The UNS item is not unique.

How can I do this?

I hope this makes sense!

Mike

 

[LonnieJohnson]

In the After Update event of the combobox you could put...

UNS = CODE.Column(1)

ProDev, MS Access Applications
Visit me at ==>

http://www.prodev.us

Contact me at ==>lonniejohnson@prodev.us

May God bless you beyond your imagination!!!