change login status

[schalkse]

Ok, am stuck on this one.

I have a form with all the navigation keys and it also lists your own name which you logged in with. Value comes from a string called strUser.

Now i have made a query (based on tblUsers) that returns me the user that is logged in and his status and acces rights. Criteria comes from the label showing the username on the form. I managed to get the value of that checkbox set to true whenever he logs in through a query on the login screen.

Now, whenever the user quits the application i want the status changed. So that the checkbox is unchecked when the user quits. this way the administrator can see who is logged in and logged out. How do i get it to false when he logs out.
Thanks in advance

 

[ghudson]

Assuming the status value is stored in a table, you need to use an update query to run when the db is closed. The query criteria should be set for the current user who is closing the db.