Message on Report

  • Thread starter Thread starter DS
  • Start date Start date
D

DS

I Have an Unbound field on a report. I want to put a message in that
field. The problem is that I want to make a form that the end user can
use to type a message that will appear in that unbound field and print
whenever the report is printed. So basically I'm saying that I want the
end user to be able to type in there own message through a form that
will be used by that report until the end user changes it.
I hope this isn't to confusing!
Thanks
DS
 
DS,
Create a form that opens just before the report. (ex. frmReportMessage)
The form can be based on a table with just one field, Message (Text 255 or
Memo if needed). The table is used to save the message for future report
runs.
On that form, place a button called ex. Run Report, and code it to open
the report. (leaving the form open)
On the report, place an unbound text control with a ControlSource of...
=Forms!frmReportMessage!Message
You can change the Message whenever you want.
 
Al said:
DS,
Create a form that opens just before the report. (ex. frmReportMessage)
The form can be based on a table with just one field, Message (Text 255 or
Memo if needed). The table is used to save the message for future report
runs.
On that form, place a button called ex. Run Report, and code it to open
the report. (leaving the form open)
On the report, place an unbound text control with a ControlSource of...
=Forms!frmReportMessage!Message
You can change the Message whenever you want.
Thanks, I'll give it a try.
Click to expand...
DS
 
Bob said:
If the Unbound field in the form is txtMessage and the form is
frmMessage, then you can place a print button on the form that will
open the report. In the report place a field
=Forms!frmMessage.txtMessage.
Don't close the form until after the report prints/previews.
Click to expand...
Thanks, Maybe I'm going about this in the wrong way. lets say I make a
bound field, then I can have that field on a form, The only thing is
then I would have to run some code to update all of the records to have
that message. Or id here a way to set the default value of a field from
a form?
Thanks
DS
 
DS said:
Thanks, Maybe I'm going about this in the wrong way. lets say I make a
bound field, then I can have that field on a form, The only thing is then
I would have to run some code to update all of the records to have that
message. Or id here a way to set the default value of a field from a
form?
Thanks
DS
Click to expand...

DS,
I think I covered that with creating a table to "hold" the message text,
until you decide to change it. If all records have a
= Forms!frmMessage!Message
unbound text control, all those records will show the same message from the
form.
hth
Al Camp
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions
 
Al said:
DS,
I think I covered that with creating a table to "hold" the message text,
until you decide to change it. If all records have a
= Forms!frmMessage!Message
unbound text control, all those records will show the same message from the
form.
hth
Al Camp
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions
Click to expand...
OK Thanks, I get it now.....!
DS
 
Back
Top