I can find out what is wrong with my code.
"TransfereeName" is a textbox where the string is either typed in or obtained from a combo. I want the "TransfereeAddress" to automatically filled in when the name is selected from the combo. The combo does contain the Address as well, but I don't know how to capture it to fill in the "TransfereeAddress" automatically.
I get the following error: Run-Time error '2001' - You canceled the previous operation.
I thought by using DLookup I can obtained the address of the Transferee.
Dim NAddress As String
This is not working
NAddress = Nz(DLookup("[Address]", "tblShareMembers", "[Member] = '" & Me.TransfereeName & "'"), "")
This one doesn't work either.
NAddress = DLookup("[Address]", "tblShareMembers", "[Member] = '" & TransfereeName & "'")
I'd appreciate your help please!!!

"TransfereeName" is a textbox where the string is either typed in or obtained from a combo. I want the "TransfereeAddress" to automatically filled in when the name is selected from the combo. The combo does contain the Address as well, but I don't know how to capture it to fill in the "TransfereeAddress" automatically.
I get the following error: Run-Time error '2001' - You canceled the previous operation.
I thought by using DLookup I can obtained the address of the Transferee.
Dim NAddress As String
This is not working
NAddress = Nz(DLookup("[Address]", "tblShareMembers", "[Member] = '" & Me.TransfereeName & "'"), "")
This one doesn't work either.
NAddress = DLookup("[Address]", "tblShareMembers", "[Member] = '" & TransfereeName & "'")
I'd appreciate your help please!!!