Invoke form if checkbox is -1

[tinyevil777]

Good morning all,

The title pretty much explains my query, but just to clarify...

If the checkbox "PQE" is ticked (-1), invoke the form "PQEFORM". I thought about using the OnClick option, but i do not want the form to be invoked if the checkbox is unticked (-1 to 0).

I'm sure it's just a simple IF statement in the coding for the OnClick, but i'm not sure where to start looking.

Any help would be greatly appreciated, thank you in advance!


Tom

 

[tinyevil777]

Ahh i think i've cracked it, does anyone envision having any issues with using:

Private Sub newpqe_AfterUpdate()
   If Me.newpqe = True Then
       DoCmd.OpenForm "Anal-PQEPOPUP", acNormal
   End If
End Sub

 

[MarkK]

Comparing to True for booleans is like multiplying by one for Integers: Makes no difference. I'd amend as follows ...

Private Sub chkPQE_AfterUpdate()
   If Me.chkPQE Then DoCmd.OpenForm "PQEPOPUP"
End Sub

... and acNormal is the default.
Cheers,

 

[tinyevil777]

Okay, thanks lagbolt!