Dlookup syntax help

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Tanya - 14 Jun 2006 07:31 GMT

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

Reply to this Message

Wayne-I-M - 14 Jun 2006 08:03 GMT

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)")

Signature

Wayne
Manchester, England.

> Hi,
>
[quoted text clipped - 9 lines]
> thanks heaps
> Tanya

Reply to this Message

Tanya - 14 Jun 2006 10:17 GMT

thank you so much.....
Tanya

>Hi Tanya
>
[quoted text clipped - 12 lines]
>> thanks heaps
>> Tanya

Reply to this Message