CheckBox to Database??

Results 1 to 3 of 3

Thread: CheckBox to Database??

  1. #1
    Francis F Guest

    Default CheckBox to Database??

    I can't seem to find the answer to my question anywhere. Here it is: What is the best way to capture Checkbox information from a form and write it to to a database? In my situation, Users have to be able to select their preferences as they fill out a client profile. I have set up 2 tables, Users and Preferences in an Access DB. The Users table will capture username, name, address, etc. while the Preferences table has preferenceID, username and preferences as the fields. Users can select as many as 15 preferences so I figured it would be better to use 2 tables. I can't figure out how to capture the Checkbox info and write to the Preferences table. Should I even have these 2 tables? Please help!

  2. #2
    Join Date
    Dec 1969

    Default RE: CheckBox to Database??

    The value attribute of the checkbox component on your form ie<BR>&#060;input id="thisID" value="thisPreference" type="checkbox" name="thisCheckBoxName"&#062;<BR><BR>is captured using;<BR><BR>myVariable = response.forms("checkbox_name").<BR><BR>If the checkbox isn&#039;t selected it does not exist in the forms collection. This help ?

  3. #3
    francis f Guest

    Default RE: CheckBox to Database??

    Thank you Dave! I&#039;ll give it a try!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts