Header problem (2)

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top