Help with DLOOKUP

[NHogan]

I have a Part Number field that when is updated, populates a Part Name field. It works fine with the current 15 digit Part Number but they are changing the Part Name to be associated with the first 5 characters of the Part Number.

Ex Part No PartName
Old 123456789012345 Bracket
New 12345 Bracket

I think it sounds like a simple change but I am getting syntax errors with my code. Below is my existing code that I want to change to look at the first 5 characters of the txtPartNo field.

DLookup "[PartName]","tblPartName","txtPartNo= [PartNo]&quot

Can't I just do a left(txtPartNo,5) in the DLookup command? When I try I am getting a syntax error with the comma. Please help.

 

[TomCologne]

Try ("txtPartNo",5).

You're not alone,

TomCologne

 

[NHogan]

I still get a Runtime Error 3075 with a syntax error. Any other suggestions?

 

[TomCologne]

Dlookup("[PartName]","tblPartName","txtPartNo=Left([PartNo],5)&quotmight work.
Hopefully?!

You're not alone,

TomCologne

 

[NHogan]

Thanks anyways, but I finally got it too work. It didn't like the Left inside of Dlookup and the problem was I had to use quotes because it was a string.

strLeftPartNo = Left(txtPartNo, 5)
DLookup("[PartName]", "tblPartName", "[PartNo] = """ & strLeftPartNo & """&quot