Dlookup syntax help

  • Thread starter Thread starter Tanya via AccessMonster.com
  • Start date Start date
T

Tanya via AccessMonster.com

Hi,

can someone help with this lookup function below
Rate_ID is a number
Rate_Item_Code and ItemID are text

i cant seem to get this to work. am i missing some syntax?


Me.txtTechRateID = DLookup("Rate_ID", "Test", [Rate_Item_Code] = " Me.ItemID.
Column(0))

thanks heaps
Tanya
 
Hi Tanya

Are you referencing items from the table [Test] on the same form ? like the
[Rate_Item_Code] which has the [RateID] of "123xyz". If so there are just a
couple of " missing.

Try this

Me.txtTechRateID = DLookup("[Rate_ID]", "Test", " [Rate_Item_Code] =
[Me.ItemID]. Column(0)")
 
thank you so much.....
Tanya

Wayne-I-M said:
Hi Tanya

Are you referencing items from the table [Test] on the same form ? like the
[Rate_Item_Code] which has the [RateID] of "123xyz". If so there are just a
couple of " missing.

Try this

Me.txtTechRateID = DLookup("[Rate_ID]", "Test", " [Rate_Item_Code] =
[Me.ItemID]. Column(0)")
Hi,
Click to expand...
[quoted text clipped - 9 lines]
thanks heaps
Tanya
Click to expand...
Click to expand...
 
Back
Top