My Assistant
Site Message
(Message will auto close in 2 seconds)
  |
 Runtime Error 3464
|
|
 Apr 18 2007, 11:49 AM
Post
#1
|
|
|
UtterAccess Guru Posts: 654 From: Michigan  |
I receive a runtime error 3464 when running the below code, which is from my Customer Contacts Table
Me.CustomerName = DLookup("CustomerName", "TblCustomerInfo", "[Customer_Code] = " & Me.Customer_Code) Customer_Code is a text data type |
 |
 
|
|
Apr 18 2007, 12:46 PM
Post
#2
|
|
|
UtterAccess VIP Posts: 23,583 From: Mississippi |
Try this instead:
Me.CustomerName = DLookup("CustomerName", "TblCustomerInfo", "[Customer_Code] = '" & Me.Customer_Code & "'") |
|
|
|
|
Apr 18 2007, 01:38 PM
Post
#3
|
|
|
UtterAccess Guru Posts: 654 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 |
|
|
|
|
Apr 18 2007, 01:49 PM
Post
#4
|
|
|
UtterAccess VIP Posts: 23,583 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. |
|
|
|
 |
|
Jump To Forum:
|
Go to Top · Lo-Fi Version | Time is now: 18th May 2013 - 07:01 AM |
Tag cloud: