Welcome to WebmasterWorld Guest from 3.81.29.226

Forum Moderators: ocean10000

Message Too Old, No Replies

Checkboxes in ACCESS

Populating an edit form

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

New User

10+ Year Member

joined:Sept 30, 2008
posts: 3
votes: 0


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..
11:10 pm on Oct 3, 2008 (gmt 0)

Senior Member

WebmasterWorld Senior Member 10+ Year Member

joined:Apr 12, 2002
posts:857
votes: 0


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.