Febrero127
New member
- Local time
- Yesterday, 18:57
- Joined
- Apr 3, 2014
- Messages
- 7
Hello guys,
I need help with this issue. I have a linked table called par3214_dms_user. In this case I will be needing User_Name and User_ID from that table (both are set to format type Text).
In a form I have a text box named Text_BadgeRDM in which the user types in there ID number and after that it should pull the name from the table and place it in to a text box named Text_NameRDM . I am getting an error "Data type mismatch in criteria expresion"
I have tried a couple diferrent ways but cant get it running. What should I change? Here is what I have right now:
Private Sub Text_BadgeRDM_AfterUpdate()
Me.Text_NameRDM = DLookup("user_name", "par3214_dms_user", "user_id=" & Me.Text_BadgeRDM)
End Sub
I need help with this issue. I have a linked table called par3214_dms_user. In this case I will be needing User_Name and User_ID from that table (both are set to format type Text).
In a form I have a text box named Text_BadgeRDM in which the user types in there ID number and after that it should pull the name from the table and place it in to a text box named Text_NameRDM . I am getting an error "Data type mismatch in criteria expresion"
I have tried a couple diferrent ways but cant get it running. What should I change? Here is what I have right now:
Private Sub Text_BadgeRDM_AfterUpdate()
Me.Text_NameRDM = DLookup("user_name", "par3214_dms_user", "user_id=" & Me.Text_BadgeRDM)
End Sub