Setting a default Value for Dynamic Dropdown List

[Qmoto]

Hello all, I'm stuck and could really use some help here....

What I've got is an update record page that displays the current values on the left hand side of the window, then next to that I give the user dropdown lists (DDL) to change or ‘update’ the record in the database.

What I need to do is set the default option in the DDL to the current value in the database, while still giving them the option of selecting one of the original values, however when I use the 'Select value equal to:' option in the aspropDownList wizard I get the following error.

<error>
BC30521: Overload resolution failed because no accessible 'FieldValue' is most specific for these arguments:
</error>


??


The reason I need to have the current value selected is that when the user submits the page, only record values that were reselected get the correct value, all others get set to Null.


???

 

[lebisol]

type it in manually:

<%=(RecordSet.Fields.Item("myfield").Value)%>

All the best!

:--------------------------------------------------------------------------:

ok,ok...I did shoot the deputy but he told me he was the sheriff!
:--------------------------------------------------------------------------:

 

[Qmoto]

Oops, I forgot to mention that I'm using .net - what's the equivalent in .net?

btw, thanks so much for giving me an answer, I've asked this question several different places and you're the only one that's answered me... I really do appreciate it!