I think I placed this post in the wrong forum. So I place here
I have a login form where users login. I want to filter the records per user. How will I go about it. Please see my code below
tblLogin
recid (autonr)
UserID (text) unique user id to login - example 'Andre'
pw (user password)
UserName (text) manually entered in tblLogin when user is added - example Andre van Zyl
tblClientInformation
'SubAgent' - example Andre van Zyl
text65 is an unbound field in frmClientInformation that collect the username when userid is entered in frmLogin. frmLogin is hidden.
When Andre (userid) login username Andre van Zyl displayed in text65 on frmClientInformation. So Andre van Zyl may only work with records where 'SubAgent' is = to Andre van Zyl
Note: Me and my wife must have full access to all records. My userid is 'johan' and wife userid is 'marlene'