Forum Moderators: open

Message Too Old, No Replies

Checkboxes in ACCESS

Populating an edit form

         

jerrybentoak

5:19 pm on Oct 1, 2008 (gmt 0)

10+ Year Member



I have an access db that the table stores a value for the days of the week. ie M,T,W,TH,F . These are stored in one field of the table. The add.asp form populates with no problem. I am having trouble getting the data back out on the edit.asp form. I want to be able to populate the check boxes on the edit form to indicate what the user previously put in. HELP..

defanjos

11:10 pm on Oct 3, 2008 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member



Can they pick more than one day, or just one day?
Does the data in the field look like "M,T,W" or "M"

The following may give you a clue:
<input type="checkbox" name="day" value="M" <%if rs("day")="M" then%> checked <%end if%>>

If the field in the database (day) equals "M", the box will be checked.