I use the find command to find users in a table by looking for the userid ex:(yoderr). But if the Userid has a number after it
ex:(yoderr1), the user account that has the 1 after it does not get included in the find. Is it possible to modify this option so that all accounts for a user included userid's with a 1 will be included.
This is the code so far:
Private Sub AllUserInfo_Click()
On Error GoTo Err_AllUserInfo_Click
' THIS IS TO FIND ALL INFORMATION THAT IS SPECIFIED FOR A
' USER BY FOCUSING ON THE USERid
Dim stDocName As String
Dim stLinkCriteria As String
stDocName = "User Table Popup"
stLinkCriteria = "[Userid]=" & "'" & Me![Userid] & "'"
DoCmd.OpenForm stDocName, , , stLinkCriteria