Hi. What I want to do is make a form with a message for a particular user pop up until it is marked as read.
I have a table for users that contains usernames and passwords (I am not using users and groups config in Access, they are stored in one of my tables) and I have a table for messages that has been linked in a n:m relationship (using a breakdown table) to the user table.
I need code that can designate the user log on to the database (I already restrict access to forms using a similar script) and also pop up the correct message for each user.
Hope someone can help