Can some one debug this Dlookup code?

[osx99]

I have a form with an option box [EarthPrev] to select different repair types which populate control [repair type] on table [Structures Input]

I have another table named [REPAIR TYPE] which has a description of the repair types with the repair type ID with fields [repair no] and [measure dimension] ([repair type] being primary key and unique)

I am trying unsuccessfully to use the following code to update [measure dimension] in [Structures input] with the corresponding row from [REPAIR TYPE] after selecting the option box button

Me![Measure Dimension] = DLookup("[Measure Dimension]", "[Repair Type]", "[Repair Type] = Me![EarthPrev]&quot

Can anyone help with correct code for populating the field in my table by looking up the correct description in the row form a seperate unlinked table?

Thanx in advance
Os x

 

[WildHare]

It might be as simple as surrounding your criteria value with SINGLE quotes - generally, if the criteria is a text guy, you need to do somthing like this:

...{rest of dlookup here}.."RepairType = '" & Me!EarthPrev & "'" )

This will resolve to something like this:

"repairtype = 'ABC'"

Note the single quotes embedded within the regular double-quoted criteria string as a whole.

Jim



Me? Ambivalent? Well, yes and no....
Another free Access forum:

http://www.forumco.com/jmhare

More Access stuff at

http://www.jmhare.com/wildhare.htm