Yes/No field

[garsidep]

Hi All,

I have a table (tbl_data) with a Yes/No field called Printed. Now I have a command button on my user form which sit's on top of my query that link to tbl_data. I what I want to do is on click the printed field in my table turns to "yes" for the record selected on my user form. I can't for the life of me work out how to do this .

Thanks for your help,
Phil

 

[DevastatioN]

Under the On Click event for the button, add the line of code:

Me.checkbox = True

Attached is a sample database of how you do this. If you don't want the checkbox to be shown to the user on the form, set the visible property of checkbox to False. The checkbox should be on the form, but just not visible.

 

[John Big Booty]

.......
The checkbox should be on the form, but just not visible.

The check box only needs to be a field in table that is the Record Source for the form. there is no need to have a check box on the form hidden or otherwise, if the user does not need to physically interact with it.