Autofill another field from combobox

mahai1ey

New member
Local time
Yesterday, 23:02
Joined
Apr 27, 2011
Messages
4
Good day. I read through the Forms threads and didn’t see anything that quite fit what I am trying to do. I have a db that tracks equipment repairs/status. On my data entry form for tblJobs, I’m trying to have the [EquipID] control auto-populate the [EquipType] control.
The [EquipID] control is a combo box having two columns: [EquipID] and [EquipType]. How do I populate the [EquipType] control with the matching data from the [EquipID].[EquipType] column of the combo box?
 
Paul, thanks - this worked excellently - and put me on the right track... Now the control to auto fill is a textbox... so I'm going to start work on that one. Have a wonderful day!!!
 

Users who are viewing this thread

Back
Top Bottom