Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Ulta Dev List Box in Update Form

Status
Not open for further replies.

Silvinho

Programmer
Jul 9, 2001
58
GB
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.
 
hi,

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

thanks
 
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
 
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
 
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!!

[shadessad]
 
ok guys,

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

-Adm. James Farragut

Stuart
 
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
BT
 
what if i create the form manually.?
how can i bind the recordset values to the menu?
 
Create a recordset then use the code below to roll through all of the records. Changing the bits in red to your own.

Code:
  <select name=&quot;select&quot;>
    <%
While (NOT
Recordset1
Code:
.EOF)
%>
    <option value=&quot;<%=(
Recordset1
Code:
.Fields.Item(&quot;
value_field
Code:
&quot;).Value)%>&quot;><%=(
Recordset1
Code:
.Fields.Item(&quot;
Label_field
Code:
&quot;).Value)%></option>
    <%
Recordset1
Code:
.MoveNext()
Wend
%>
</select>

Cheech

[Peace][Pipe]
If you don't stand up for something, you'll fall down. Toke it Easy.
Howard Marks.
 
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?
 
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.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top