common field displayed on all forms

[CliffordTheRedDog]

I need a common numeric field (nest number)on all forms that print through a macro.I have tried to insert the properties on every report

[table]![cutting list number]![nest number]

This does not work so i tried

table.cutting list number.nest number

No joy!
Any advice appreciated.
TIA
Cliff

 

[dhookom]

Are you actually printing forms rather than reports? Consider always printing reports. I would create a small subreport that displays the value and add this subreport as necessary to other reports.

Duane
MS Access MVP
Find out how to get great answers faq219-2884.

 

[CliffordTheRedDog]

Duane,
Forms? It's late and i have spent all flippin day on this!!!
Reports, i mean reports. what a twit.
Cliff

 

[dhookom]

Cliff,
Did you try my suggestion? Did it work? You could probably also use a text box bound to:
=DLookup("[nest number]","[cutting list number]")
This assumes there is only one record in the table and it is the value you want to display.

Duane
MS Access MVP
Find out how to get great answers faq219-2884.

 

[CliffordTheRedDog]

Duane,
I will try the second data
=DLookup("[nest number]","[cutting list number]")
i was not sure whether the first lot would work as i am working on reports... will get back asap
Ta Cliff

 

[CliffordTheRedDog]

Duane,
That is exactly what i needed, thank you so much.
Cliff