T
tracey
I have included the code as requested. In the previous
response some one suggested cancel= true. I don't
understand?
Thanks
Private Sub Form_Open()
If Me.TableLink = 0 Then 'checks refresh for false
cmdNav_Click ' this runs the proc wich refreshes tables
Me.TableLink = -1 ' updates the refresh to true
DoCmd.Close acForm, Me.Name 'closes this form
DoCmd.OpenForm "frmLogin", acNormal 'opens the login
form
Else 'if the ref is true then close form and open login
DoCmd.Close acForm, Me.Name
DoCmd.OpenForm "frmLogin", acNormal
End If
End Sub
response some one suggested cancel= true. I don't
understand?
Thanks
Private Sub Form_Open()
If Me.TableLink = 0 Then 'checks refresh for false
cmdNav_Click ' this runs the proc wich refreshes tables
Me.TableLink = -1 ' updates the refresh to true
DoCmd.Close acForm, Me.Name 'closes this form
DoCmd.OpenForm "frmLogin", acNormal 'opens the login
form
Else 'if the ref is true then close form and open login
DoCmd.Close acForm, Me.Name
DoCmd.OpenForm "frmLogin", acNormal
End If
End Sub