dynamic list/menu

message from jjrmy1 on 21 Jul 2004
I would greatly appreciate any advise on this. Thanks
I'm using access tables and .asp.
a list of catagories is kept in one table, in which a dynamic list/menu box connects to to give your choices.
The current catagory is inserted and kept in another table (with other information). I need the initial value of the list/menu box
to be the current catagory.
Does anyone know how i can get the list/menu box to have the values of one recordset and the initial value of another recordset.
or you if you could direct me to a good tut.
thanks.
 
~Angela, TMM replied to jjrmy1 on 21 Jul 2004
Hello jjrmy,

1. Create a recordset just for the purpose of populating the list. (Don't
actually add it to the list yet.) rsMyList

2. Create the recordset used for display on the page. rsMyData

3. Set up the page to display the data. (Still don't add the data to the
list menu yet).

4. Click the list menu in Design view and then click the Dynamic button on
the Property inspector.

5. Options from recordset should be set to the recordset for populating the
menu. Set the Values and Labels fields accordingly. The key is, set the
Select value equal to the appropriate field in rsMyData. To do so, click the
lightening bolt, and choose the field in the dialog that appears.

That's it!

Good luck,
~Angela
 

Archived message: dynamic list/menu (Macromedia Dreamweaver Web Design)