Hi guys, I am setting up our notes to work for each person so any leader can send a note to any of our workers by name and only that person will get the message only on the dashboard. After they login and are working and we send a note to them for some reason the messsage "they have a message" (which is a txtbox),is not getting visible on the dashboard, that is on the frontend of our split database. I use the main split one. The dashboard has their name, and another form shows all the names and we use a checkbox to send a note to a specific person. I am using Dlookup on the dashboard to make the txtbox visible to show that person the message on the dashboard. I don't know what else to add to the code because it's not showing the message. this is the code on the dashboard in a public sub. On the nonsplit one it works good.
If Me.CounselorFirstName = DLookup("CounselorFirstName", "Signup", "chkyesno = True") Then
            'Me.txtbox.Visible = True
    
        End If