Updating a forms drop down menu

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

   I've created a basic access database, using asp pages to read record and write new records.

I'm on working on updating exsiting records in the database. The user
can add a new record to the database using a complicated HTML form. In
this form I have some drop down menus, where the user can pick
diffierent choises to enter.

For updating an exsiting record I want to use the same form. But, I
don't know how to get the drop down menu to show the correct entry in
the record. Here is an example of my code...

<tr><td>WebQuery Purchased:</td><td>

         <SELECT name="WebQuery">

<OPTION><% Response.Write (rsGuestbook("WebQuery"))
%></OPTION>

             <OPTION selected value="true">True</OPTION>

             <OPTION selected value="false">False</OPTION>

         </SELECT></td></tr>

Thanks!!