dlookup

[doug]

how do i put a dlookup statement into a string that i want
to execute as sql command. I have something like:
strSQL = "insert into table (item) values dlookup("value",
table)"

how would i go about fixing that
thanks

 

[Wayne Morgan]

Doug,

See the reply to your previous question. You're right, you caught the
problem.