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
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