How can I update field 2 based on contents on field 1

[bloggsie]

This is driving me bonkers can anyone please help!!!

I have a form to enter production figures for a day. If I choose a 'tool' from a combo box, the 'tool' I select is entered into the field, but how can I get it to automatically update a second field on the same table based on the 'tool' I pick.

eg. lookup table for combo box contains:

TOOL SIZE
a 1"
b 2"
c 3"

If I select 'tool a' in combo box, how can I get it to automatically put 1" into the next field so it doesn't have to be typed in??

Please, I am struggling.

 

[ghubbell]

On After Update of FirstCombo (Make sure your first combo is carrying the data you need for the next field in another column... as you've listed above):
Me.SecondTextBox = Me.ComboBoxName.Column(2) .. Combobox columns are zero based so start your column counting at 0.
You could also use the DLookup function.
Gord
ghubbell@total.net