I am using DW MX and CF MX. I have created an insert form and an update form for my access database. How should I set up a static list for a drop down field? I have each drop down field starting with a "Select" label and NO value. Otherwise would not the new or edited record show the FIRST item in the list? For example, in the Occupation field, the first real item is ACTOR. In the update form, the drop downs are ALL reset to the SELECT item in the database. How do I set these fields up so that the database will not have anything entered in the drop down list till I say so?

Ken

Sample text:
<select name="ClaimtoFame">
<option>Select</option>
<option value="Actor">Actor</option>
<option value="Actress">Actress</option>
<option value="Author">Author</option>
<option value="Coach">Coach</option>
<option value="Entertainer">Entertainer</option>
<option value="Politician">Politician</option>
<option value="Musician">Musician</option>
<option value="Racing">Racing</option>
<option value="Sports Figure">Sports Figure</option>
</select>

I'm not really understanding your question.

Do you mean that when a user open a page with a update form, the page should not have a drop down list populated with select items?

Or when a user open an update page, do you want the list to be populated and the value for the record to update is already selected?

Or when you update a record, the value is updated as "select", rather than updating with the value selected?

Or something else?

- Noz