Checkbox

[justauser]

I have a checkbox on my form that when "Checked" I would like to have a message pop up to tell the end user to use another form. I would like this message to populate any time a record is accessed with that box checked. Can anybody point me in the right direction?

[pbaldy]

The current event fires when the form loads and when the user changes records. You could put code there to test that field and fire a message box.

[justauser]

Thanks for the direction. I having a hard time writing the code. This is the code that I have written.

Private Sub Form_Current()
If Forms!Table1!CheckBox1.CheckState = Yes Then

MsgBox ("Checked")

End If

End Sub

I am a newbie at this coding thing. I've just been reading up and doing online tutorials for the VBA coding. Any help would be great. Thanks.

[pbaldy]

Try

If Forms!Table1.CheckBox1 = True Then

[justauser]

I guess I should add that when I run this code I get this error.

Run-time error '438':
Object doesn't support this property or method

[pbaldy]

Did you try the code in post 4?

[justauser]

I did try the code. It is populating the message box, but only when the form itself loads. Is there a way to link that message box back to the checkbox on the form?

[pbaldy]

If you want it to fire when the user checks the box, you'd need the same code in the after update event of the checkbox.

[justauser]

I don't know if it matters, but I have a combo box that is searching for and pulling in the records.