Ulta Dev List Box in Update Form

[Silvinho]

When I create an update record page in ultradev alll the fields work correctly
except drop down menu/list box type fields.

The form doesn't show the current record in the <option selected>
box and doesn't update the databse when its changed.

Ultadev does the form for you and has the list box menu option but it never works.

 

[malikainny]

hi,

did you figure any way to work around this? i'm stuck at the same point and dunno what to do....

thanks

 

[Microbe]

Have you told UD what to put in the list box as the default value?

You can choose a field from the recordset.

I have no trouble with it working. Steve Davis
hey.you@hahaha.com.au

http://www.hahaha.com.au

 

[malikainny]

hi,

i worked another way around this,
i created a table in the db and stuffed all the names and values there
on update page i created a recordset for this table and now i just call this table and and then select the values that match between this table that stores all values and the earlier table which contains the user-selected value
e.g.
post page = states = user selected it as NY
create a table in DB for all states
update page = display states table, look for the value that matches the states table and table where user selected NY was entered and highlight it

works perfect for me now

 

[toddocallen]

I am in DW MX, and the dynamic list works well using the dynamic default value UNLESS you have multiple selections, then it highlights NOTHING!!

I NEED HELP!!

 

[schase]

ok guys,

post the code for the drop down box's please. &quot;Damn the torpedoes, full speed ahead!&quot;

-Adm. James Farragut

Stuart

 

[CTekMedia]

I have never had a problem with these functions, either having the list box write to a table or pulling the info dynamically from the table to populate the list box and then having the box write to the proper table/field.

What code environment are you using - asp or CF or? Peace

http://www.bluetone.biz

BT

 

[fgeorge]

what if i create the form manually.?
how can i bind the recordset values to the menu?

 

[fgeorge]

asp..

 

[Cheech]

Create a recordset then use the code below to roll through all of the records. Changing the bits in red to your own.

  <select name=&quot;select&quot;>
    <%
While (NOT

Recordset1

.EOF)
%>
    <option value=&quot;<%=(

Recordset1

.Fields.Item("

value_field

&quot;).Value)%>&quot;><%=(

Recordset1

.Fields.Item("

Label_field

&quot;).Value)%></option>
    <%

Recordset1

.MoveNext()
Wend
%>
</select>

Cheech

[Peace][Pipe]
If you don't stand up for something, you'll fall down. Toke it Easy.
Howard Marks.

 

[fgeorge]

what i mean is this..

i have an update form with drop downs populated from a database..
how do i get those drop downs to automatically select the value that is chosen in that recordset?

 

[Cheech]

You click on the dynamic button in the select properties and set the select value to the recordset of your choice

[Peace][Pipe]
If you don't stand up for something, you'll fall down. Toke it Easy.
Howard Marks.

 

[fgeorge]

i think it works now..
thanks cheech..