Database entry from Dynamic Drop down

Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic

   I have followed the tutorial on adding information to an Access database from a user input form. However, I would like to add into the database a selected option from a dynamically populated drop down list.

Code for adding form field to database is as follows:

rsAddComments.Fields("Requested_by") = Request.Form("Requested_by")

I understand that I have to use the value of items from the drop down list to populate the Access field but how can I gleam this information from what has been selected?

Cheers