txtbox bound to another table

[philfer]

I have a report based on a particular table.

I have another table that hold the "Calculation date" for the day the process is run (it might not be today!).

When I add a textbox to this report and set its Control Source to the other table every time I try to open the report it prompts me for the value.

Is there any way to add this field?

Thanks
Phil

[OBP]

Are you using the Dlookup function?

[philfer]

Not yet - is that a hint? Should I be?

[OBP]

In the report you can have an Unbound Field and use the Dlookup function to look up the value from a different Table.
Take a look at the VBA Editor's help on Dlookup.