ms access filter subform based on multiple checkboxes (1 Viewer)

[MajP]

Probably have to post what you have. Was it working as you expected in the last version I posted? #56

 

[Kobs]

Your last database example is working. I just copied all your code but mine is not working. I added a new button though for checkbox report. Attached is my database.

 

[MajP]

For each of the checkboxes there is a TAG property. Look at that. This allows looping, and ability to simply add more checkboxes without rewriting code.
'01*' ... '05*'

 

[Kobs]

MajP,
Thanks. Its now working.

 

[Kobs]

MajP,
How to create a logout navigation button?

 

[MajP]

How to create a logout navigation button?

What is that? Describe what you want to do.

 

[Kobs]

I want to add a logout button.

 

[MajP]

I want to add a logout button

Not very helpful
Do you want to quit the application?
Return to the login form?
The Application.Quit method will close the database if that is what you mean.
If you return to the long in form you need to set the tempvars to null since it appears you are using them to store user login information

 

[Kobs]

When i press the logout button I want to just logout and not to close the database. Is that possible?

 

[Kobs]

Logout and return to login form.

 

[MajP]

I do not know how you login works. My guess is something like this.

Public Sub LogOut()
  Dim frm As Access.Form
  For Each frm In Forms
    DoCmd.Close acForm, frm.Name
  Next frm
  Application.TempVars("tempCurrentUser") = Null
  Application.TempVars("loginCorrect") = False
  DoCmd.OpenForm "frm_login", , , , , acDialog
End Sub

 

[Kobs]

Where do i place the code?

 

[MajP]

Place code in a standard module like you greeting module. Then you can call it from any button (any or all forms) or other event, by simply.
Private sub SomeButton_Click
logout
end sub

 

[Kobs]

there is an compile error: expected variable or procedure, not module

 

[Kobs]

There is an compile error: expected variable or procedure, not module

Private Sub cmdLogOut_Click()
LogOut
End Sub

 

[MajP]

There is an compile error: expected variable or procedure, not module

Private Sub cmdLogOut_Click()
LogOut
End Sub

Just to be clear that is not meant to go in a module. That is an example of how you would call the code that is in a standard module.

 

[Kobs]

yes I put that code in onclick button.

 

[Kobs]

MajP are you online? pls help.

 

[Kobs]

help anyone?

 

[MajP]

Please post the DB. If it breaks in code, please post screen shot of where it breaks in vbe.