X   Site Message
(Message will auto close in 2 seconds)

Welcome Guest ( Log In | Register )

 
   Reply to this topicStart new topic
> Runtime Error 3464    
 
   
Golfnutt
post Apr 18 2007, 11:49 AM
Post#1


UtterAccess Guru
Posts: 654
Joined: 8-April 03
From: Michigan


I receive a runtime error 3464 when running the below code, which is from my Customer Contacts Table
e.CustomerName = DLookup("CustomerName", "TblCustomerInfo", "[Customer_Code] = " & Me.Customer_Code)
Customer_Code is a text data type
Go to the top of the page
 
fkegley
post Apr 18 2007, 12:46 PM
Post#2


UtterAccess VIP
Posts: 23,637
Joined: 13-January 05
From: Mississippi


Try this instead:
e.CustomerName = DLookup("CustomerName", "TblCustomerInfo", "[Customer_Code] = '" & Me.Customer_Code & "'")
Go to the top of the page
 
Golfnutt
post Apr 18 2007, 01:38 PM
Post#3


UtterAccess Guru
Posts: 654
Joined: 8-April 03
From: Michigan


Excellent!
Im still trying to learn about the proper syntax structure.
All those single and double quotes are very confusing.
Thanks again Frank
Go to the top of the page
 
fkegley
post Apr 18 2007, 01:49 PM
Post#4


UtterAccess VIP
Posts: 23,637
Joined: 13-January 05
From: Mississippi


Yes, they are. The single quote is used inside double quotes, normally to delimit a text value. # are used around date values, nothing around numbers that are not dates.
You're welcome. I am glad I could help.
Go to the top of the page
 


RSSSearch   Top   Lo-Fi    24th January 2015 - 10:46 PM