drop down menu/combo box 2

[tziviak2]

I want the user to be able to choose from a list and according to the value-I want to insert a value in a table.
ex. user can choose from apple/banana/pear. if the user chooses apple-then enter 1 in the field, banana-2,pear-3.
I need the user to choose from many different lists-before they press on a button-to record the value. how would I go about it?
thank you

 

[Lothario]

Try this:

sql="UPDATE tblGoalsReportCard SET MeasuMeth = " & request.form("MOM") & ", ProgReport = " & request.form("ROP") & ", ProgTowardsGoal = " & request.form("PTG") & ", ReasNotMeetingGoal = " & request.form("RFNMG")
sql=sql & " WHERE tblGoalsReportCard.rcRecNum= " & rs("rcRecNum")

-L