i have numerous reports based on various queries, i have a table called [centre info] which containes [id](auto number) [name] (location of centre (as text)), [address] etc

i am trying to set the reports on event property to set text box [text35] to tables![centre info]![name]

so far i've tried dlookup and VB code

Dim centrenm as string

with [id]=1
centrenm=tables!"centre info"![name]
end with

text35.text = centrenm





doesn't work?


can anyone help


thanks