Hi.
What I need to do is to use a drop down combo-box to create five different options (that I've done). The user then selects lets say option 1. Then later on in the form there is another question to enter a number, lets say 200.
I want access to put the 200 into the column relating to option 1 in the table (or option 2 etc if that were selected), leaving the other options in the table blank.

Is there anyway of doing this????

Thnaks a million

Use the afterupdate event of the combo box to populate the relevant box.

Combo1_AfterUpdate()
Select Case me.Combo1
Case 1
Me.Option1 = 100
Case 2
Me.Option2 = 200
Case 3
Me.Option3 = 300
etc..
Case Else
End Select
End Sub

HTH

Ian