Adding Report Field linked to a Form

[ricseb]

I'm trying to add a last note date field into a form that will reflect this
date in a report. My question is this: how do I link the report date field
to reflect this info into a report with a column named "Last Note Date"? I
hope this is enough explanation for a response.

Thanks.

ricseb

 

[Al Campagna]

ricseb,
Give the ubound text control on the report a ControlSource of...
= Forms!YourFormName!YourNotes
But, it would seem that the Notes should be a bound field on your form, and saved along
with any other data. Consequently, it should be available to the report as a normal table
field,

--
hth
Al Campagna . Candia Computer Consulting . Candia, NH USA
Microsoft Access MVP
http://home.comcast.net/~cccsolutions

"Find a job that you love, and you'll never work a day in your life."

 

[Marshall Barton]

I'm trying to add a last note date field into a form that will reflect this
date in a report. My question is this: how do I link the report date field
to reflect this info into a report with a column named "Last Note Date"? I
hope this is enough explanation for a response.

Not quite enough information ;-)

A report text box can refer to a form text box by using an
expression like:
=Forms!theform.theformtextbox

However, if the form text box is bound to field in the
form's record source, you should make sure that the record
is saved before opening the report. This can be done in the
form button that opens the report:
If Me.Dirty Then Me.Dirty = False

 

[ricseb]

Al, thanks a lot for the tips. I'll try what you suggested and play around
with it. The control that I need to insert in the form actually needs to be
reflected in several reports. I knew that there was an expression I needed
to add, but wasn't quite sure which one. I'm going for Access Certification
soon - are there any advanced Access books/tutorials that you would suggest
studying from for this endeavor? Your comments are most appreciated.

Ricky Sebastian

 

[ricseb]

Thanks for the tip Marshall.

Ricky Sebastian

Not quite enough information ;-)

A report text box can refer to a form text box by using an
expression like:
=Forms!theform.theformtextbox

However, if the form text box is bound to field in the
form's record source, you should make sure that the record
is saved before opening the report. This can be done in the
form button that opens the report:
If Me.Dirty Then Me.Dirty = False