Dlookup Function

[Curt Hand]

I have put and event function on the Lost Focus of one of my fields in a form
and it will not work. The following is the code:
Private Sub CustomerNumber_LostFocus()
ClientName = DLookup("CompanyName", "tblClients", "CustomerNumber='" &
[CustomerNumber] & "'")

End Sub

When I hit the tab button I get a Run-time error '3464'

I have looked up the error and I can't figure out what the problem is.
The tblClients.CustomerNumber is an auto number type and the forms
[CustomerNumber] is a number type.

Your help is greatly appreciated.
Thanks,
Curt Hand

 

[Duane Hookom]

Ditch some of the quotes:
ClientName = DLookup("CompanyName", "tblClients", "CustomerNumber=" &
[CustomerNumber] )

 

[Curt Hand]

Thanks Duane you are always a great help. It works great.

Ditch some of the quotes:
ClientName = DLookup("CompanyName", "tblClients", "CustomerNumber=" &
[CustomerNumber] )

--
Duane Hookom
MS Access MVP
--

I have put and event function on the Lost Focus of one of my fields in a
form
and it will not work. The following is the code:
Private Sub CustomerNumber_LostFocus()
ClientName = DLookup("CompanyName", "tblClients", "CustomerNumber='" &
[CustomerNumber] & "'")

End Sub

When I hit the tab button I get a Run-time error '3464'

I have looked up the error and I can't figure out what the problem is.
The tblClients.CustomerNumber is an auto number type and the forms
[CustomerNumber] is a number type.

Your help is greatly appreciated.
Thanks,
Curt Hand