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

dandavis1 · #1 06-04-2009, 06:55 AM

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!!!

ConneXionLost · #2 06-04-2009, 12:17 PM

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,

Welcome to the Excel Forum

Forum Statistics