+ Reply to Thread
Results 1 to 2 of 2
  1. #1
    Forum Contributor
    Join Date
    06-11-2008
    MS-Off Ver
    2003
    Posts
    193

    How to link a check box on a form to a table

    Hi,

    I have created a form which currently has a checkbox on it along with some other data. I recently have been asked to add another check box titled 'On Record' onto the same form, however when I check the 'On Record' box and save the sheet it is not registering on the table and just shows the 'On Record' box un-ticked.

    What am i doing wrong?!? Can you only have 1 check box per form, so would i be better off using a different method?

    Thanks!!!

  2. #2
    Forum Moderator ConneXionLost's Avatar
    Join Date
    03-11-2009
    Location
    Victoria, Canada
    MS-Off Ver
    2003 & 2010
    Posts
    1,791

    Re: How to link a check box on a form to a table

    Hi dandavis1,

    There's no "one per form" limit for checkboxes.

    Check the usual suspects:

    1. Ensure the table has a field to hold the "OnRecord" data. (Usually a Yes/No data type, but it doesn't have to be.)

    2. If you've linked the form's "Record Source" to the table via a query, ensure the query also contains the "OnRecord" field.

    3. If you've already added the checkbox to the form, ensure the checkbox "Control Source" is linked to "OnRecord".

    Cheers,
    Docendo discimus.

    Please consider:
    • Thanking those who helped you. Click the reputation icon in the contributor's post and add Reputation.
    • Cleaning up when you're done. Mark your thread [SOLVED] if you received your answer.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.2.0