Update Record, Using Radio or List box? or textbox?

[webstaffuk]

Hi,
I just wondered what is the best way to edit my recordset and make it as easy as possible, as im so lazy in my edit pages I just have the record pulled for me aand the data goes into text boxes or text areas for me to edit then hit the update button....

This all works well, BUT some options are for simple Yes No answers and I sit and type yes or No when i could just click a radio button or list box and not have to type....lazy Huh??

My problem is I cant figure out how to initially get the recordset field values to get set to the radio buttons or list boxes so if they are not altered on the records update they will say as before...

I hope that all makes sense..

Thanks for any suggestions on how to achieve this .
W

[Newsgroup_User]

I'm not sure I follow. You are creating an update form and want to
show things like yes/no boxes checked (as from the recordset) but do
not want users to change them?

--

[webstaffuk]

Hi,
Yes I have the update page and for a field in the database that holds a value yes or no .

Just now when I call the edit page it opens and the recordset fileds are pulled into text boxes.

So I tried changing one of the textboxes for a List box and when the edit page opens I cant seem to bind the list box to the recordsets origional value so its opening blank or with the initial value set in dreamweavers properties at design time.... I looked in the listbox properties for a way to set its initial vale to the recordset as the text boxes do but its not letting me i dont seem to have the option to do this?

so when you hit the update button you have to make sure your option is set to yes or no again before you update using the list box with no initial binding..

I hope that made better sense
Thanks

[webstaffuk]

Hi Philo,
Im such a Dumb ass at times...
I just had another look and have figured out how to do it, I never saw that i could set default values and a dynamic initial value in the list box....

Thank you for your reply.
W

[Newsgroup_User]

default values and a dynamic initial value in
> the list box....

I know how you feel. My first radio group I could not find how to set
the default and finally I stumbled upon it.

good luck

--