PDA

View Full Version : binding a selection from a drop down menu to a form variable



eskimo
10 May 2009, 09:48 AM
Hello

I'm using Dreamweaver MX 2004

I am making a backend update section for a site.
Here is what I need to do:

Let the user select which record to update from a drop down menu
Update the record

What I have done is:

I made a drop down menu which is filled dynamically from the database
I have made an update record form with the update record form wizard in Dreamweaver
Now, I need the form to display (and then update) the record which the user selected from the drop down menu

Right now, it just displays the first record from the recordset.


So, I have made another recordset, which is equal to the form variable (which should be defined from the drop down list), and the update record form wizard is getting its data from the for second recordset. I think I'm binding the form variable wrong though or something, because i get the update form always still displays the first record in the database.

How do I bind the form variable to the selection in the drop down menu, and do I have to go to another page to display the update form, or will it refresh to the recordset selected (by the form variable) automatically?
Thanks!!