Data Slave
New member
- Local time
- Today, 08:53
- Joined
- Feb 22, 2000
- Messages
- 9
I have 2 combo boxes - one called QUADNAME and one called QUADCODE. Each one of them is a combo box with the quadname and the quadcode. The QUADNAME box has the quadname first and then the QUADCODE. The QUADCODE box has the code and then the name. I want to be able to scroll through the QUADNAMEs and the QUADCODE box to show the code that coresponds to the name. The values for these combo boxes are stored in a table called QUADCODES. I then want the values from these combo boxes (one box or both) to be stored in a table called OMINOUS. I'm really confused about how to do all of this. I don't have experience with Visual Basic so I've been searching everywhere on how to write the code. I tried using the:
Me.[Field2]=Me.[Field1].Column(1)
method, but I can't get it to work. I would appreciate any advice. I would rather not use the DLookUp function if I don't have to.
Thanx for your time.
Me.[Field2]=Me.[Field1].Column(1)
method, but I can't get it to work. I would appreciate any advice. I would rather not use the DLookUp function if I don't have to.
Thanx for your time.