I have two tables: tblAlphaRoster and Next Customer
I want to pull data from one field AlphaRoster, called SGLI, into Next Customer.
Each table has a unique field for each person called NameLast4, which comprises of the person's last name and last four of the person's SSN.
In an effort to pull the data from AlphaRoster to my Next Customer form, I created a Lookup field in my query. Unfortunately, I keep getting an invalid syntax error.
SGLICoverage: DLookup("SGLI", "tblAlphaRoster”, "NameLast4 = ‘” & Forms!frmSignInPageNextCustomer!NameLast4 &”’”)
What am I doing wrong?
I want to pull data from one field AlphaRoster, called SGLI, into Next Customer.
Each table has a unique field for each person called NameLast4, which comprises of the person's last name and last four of the person's SSN.
In an effort to pull the data from AlphaRoster to my Next Customer form, I created a Lookup field in my query. Unfortunately, I keep getting an invalid syntax error.
SGLICoverage: DLookup("SGLI", "tblAlphaRoster”, "NameLast4 = ‘” & Forms!frmSignInPageNextCustomer!NameLast4 &”’”)
What am I doing wrong?
DLookup in Query
