Updating a Checkbox in a Form

[groovnvirginia]

Hello all, I have a simple access db with one table and 5 columns [ID, FIRSTNAME, LASTNAME, DOB, CORRECT]. Column 5 is a yes/no column.

I have a search box that is pulling up records into a form that match a certain criteria which works fine. Once I am at the desired record I want the user to validate column 4 [DOB] and then click on the check box to designate that it is correct or not and then update column 5 [Correct].



So far no luck or success. I have tried writing VB to update the column on click but it seems to do nothing.

Also, how hard would it be to allow them to up the [DOB] and save it?

As you can probably tell I'm a newbie to Access.

v2010

Thanks and any suggestions welcome.

[Robeen]

Is your Form 'bound' to the Table?
[If it is - you should see the Table name in the Form's Property Sheet - Data tab - Record Source].

If the Form is bound to your Table - you shouldn't need to write any code to save anything on the form. As soon as you go to another record, Access automatically saves your changes - including whether the check-box is checked or not-checked.

Maybe I have not understood what you're trying to do.
Could you explain in different words?

[groovnvirginia]

Robeen, that was it.. I also noticed that the "Allow Edits" was set to No so between the 2 that fixed it.

Thanks!

[Robeen]

Happy to help! All the best.