can anybody see anything wrong with

[antdickens]

can anybody see anything wrong with this statement.

i am trying to select the description from the datafromchance table which has the same stock code as the pcode field on the form.


Me.desc1 = DLookup "[description1]", "datafromchance", "[stockcode] = me.pcode &quot

i get a runtime error 2001

you cancelled the previous operation


all help greatly appreciated

 

[smedvid]

Me.desc1 = DLookup ("[description1]", "datafromchance", "[stockcode] = me.pcode &quot

Are u missing a " ( " after DLookup? Steve Medvid
"IT Consultant & Web Master"

http://users.erols.com/medvid/

 

[Maquis]

You need to take the me.pcode out of the quotes since it's a variable. I believe you are also missing a beginning parentheses.


Me.desc1 = DLookup ("[description1]", "datafromchance", "[stockcode] = " & me.pcode)


Maq B-)
<insert witty signature here>