Is This At All Possible? 1

[Rjc8513]

Maybe I'm going about this the wrong way but, I have five reports- let's call them Rpt1, Rpt2, etc. I want each report to have a custom footer so that the user can input whatever he/she desires, i.e., "Call 555-1212 for assistance", etc.

I have created a table called [tbl REPORT FOOTERS] with the fields [Rpt1 Footer], [Rpt2 Footer], etc. I have an input form [frm REPORT FOOTERS] bound to [tbl REPORTS FOOTERS]. I want the user to be able to add or edit the footer for each report from the form and have [tbl REPORT FOOTERS] updated.

Should I use the SQL UPDATE statement? Should I use an Update Query? Any help would be appreciated. Thanks.

Richard...

 

[nickjar2]

Just had a look, when u do it manually there should be an 'Advanced' button somewhere along the line. Here u should be able to do a Save as.

Nick

 

[nickjar2]

Oops. Sorry. Wrong thread.

Nick

 

[JoeMiller]

Add a reference on your report to the form and the appropriate text box. When the report is run it will look to the text box on you form for it's information. Here's an example of how to reference the form in the control source of your text box.

=[Forms]![frm REPORT FOOTERS]![FooterTextBoxName]

You don't necessarily need to have the form tied to a table, you could use an unbound form with unbound text boxes so the user types in a value and then it appears. This however is a up to you. Another way to do, though less appealing if you ask me, is to put an unbound control in the reports footer that prompts for user input when the report is run. The control source to do this would be like this:

=[Enter the report footer:]

Then you'd get an input box when the report is run.

HTH Joe Miller
joe.miller@flotech.net