Dlookup question

[nkenney]

Hello,



I am having a problem populating a unbound field (Year). I have a field named tag. Based upon the tag field I want to populate the unbound field Year. In my instanct Tag = 303KIE03 and year = 2002.

I have created the following dlookup statement:
Year = DLookup("[Year ]", "Vehicle", "[Tag ] = " & Me!Tag)

I get the following error:
Run-time error '3075'
Syntax error (missing operator) in query expression 'Tag = 303KIE03'.

I know I need to get single quotes around 303KIE03 but all of the combinations I use are invalid. Can you please provide the correct one.

Thanks,

[RuralGuy]

Year = DLookup("[Year ]", "Vehicle", "[Tag ] = '" & Me!Tag & "'")

[nkenney]

Thanks!

[RuralGuy]

You're welcome. Are we ready for the Solved thread tool yet?