Header problem (2)

  • Thread starter Thread starter ANSWER
  • Start date Start date
A

ANSWER

Hi,

I have report. In header of this report I want to input data from table.
Because data in report header has to be changed occasionally and he can
change data in that table although he use mde database.

I try this:

Use DLookup() in the ControlSource of a text box on your report, e.g.:
=DLookup("NameOfYourFieldHere", "NameOfYourTableHere")


but error has occur:

The expression you entered contains invalid syntax.

You omitted an operand or operator, you entered an invalid character or
comma,
or you entered text without surrounding in quotation marks.

What I have do wrong?

Thanks
 
Back
Top