LeeHutchins
New member
- Local time
- Today, 18:41
- Joined
- Nov 3, 2020
- Messages
- 13
Having the following message appear after using the below code,
Run-Time error '3075':
Syntax error (missing operator) in query expression 'ManagerCode - 813 L'.
could the issue be because of the characters spaces and numbers?
this is a long standing manager code format within the business that i cant change and i fear changing this for the purposed of my form will confuse some.
thanks in advance
Run-Time error '3075':
Syntax error (missing operator) in query expression 'ManagerCode - 813 L'.
could the issue be because of the characters spaces and numbers?
this is a long standing manager code format within the business that i cant change and i fear changing this for the purposed of my form will confuse some.
Code:
Private Sub AccountManagerInput_AfterUpdate()
Dim ManagerName As String
ManagerName = DLookup("ManagerName", "AccountManagerTable", "ManagerCode = " & Me.AccountManagerInput)
Me.AccountManagerName = ManagerName
End Sub
thanks in advance