Checkbox Control Event

[duffer 54]

Hi all,

I want to have a checkbox on my form. I want to have a form open when I
change the value to true. I have the tried following code on my on enter and
aferupdate property. Neither have worked. Any help would be much
appreciated.

On Error GoTo Err_Check26_Click

Dim stDocName As String
Dim stLinkCriteria As String
If Me.Check26 = "True" Then

stDocName = "Form1"
DoCmd.OpenForm stDocName, , , stLinkCriteria
End If

Exit_Check26_Click:
Exit Sub

Err_Check26_Click:
MsgBox Err.Description
Resume Exit_Check26_Click

Thanks,
Martin

 

[Nick via AccessMonster.com]

I want to have a checkbox on my form. I want to have a form open when I

change the value to true. I have the tried following code on my on enter and
aferupdate property. Neither have worked. Any help would be much
appreciated.

Martin,

I think you need to move the code to the Click event of the checkbox. I have
used the same type of thing in the past, and it always worked smoothly in the
Click event.

Hope it helps,

Nick