Do Not Show This Screen Again

[ggs]

Hi there

I have a check box on a form for User Notes to "Not Show Again"
Starts as unticked and the user has a close button to close and open the next form, but when they tire of seeing this form the box can be checked
but it aint working
check box is [hideform] I have a simple table to hold the value

Option Compare Database
Option Explicit

Private Sub Form_Load()
If Not Me.hideform = True Then
If Me.hideform = False Then
DoCmd.Close acForm, Me.frmLogonNotes
End If
End If
End Sub

Private Sub Form_Unload(Cancel As Integer)
DoCmd.OpenForm "frmLogon"
End Sub


help please

[pdebaets]

Try this:

Private Sub Form_Load()
If Me.hideform Then
    DoCmd.Close acForm, Me.frmLogonNotes
End If
End Sub

[rpeare]

checkboxes are stored as 0 for false -1 for positive so you might try:

If me.hideform = 0 then
     DoCmd.Close acForm, Me.frmLogonNotes
else
     'Do whatever
End If

[ggs]

mmm these pop up with an error
Method or Data Member not found and the Me.frmLogonNotes highlighted.
Ive triple checked form name spelling
but DoCmd.Close acForm, "frmLogonNotes"
fixed it
Thankyou for your help