Report data + title Help - newbie

[xlt-hunter]

HI all, a newbie here to these forums.

I have been lurking for a few days now and some of the post here have helped me in the designing of the database so thanks for those.

The issue I am having is with the report I am designing now as I want to do the following.

On Clicking on the report via a command button on the main form - I am looking for something that will open a caption box to enter a title for the report and add this onto the report (this is a must as it changes each time)

In the report it runs a query which opens a caption box asking for a code (code of the product) so type this in and it gets the data to that code and enters it into the report. How do I get the report/query to restart itself to add another line of a different product code + data on the same report - as I am a little lost how to do this.

Many Thanks

Michael

 

[Smart]

In your query that the report is based on add a new column;

Reptitle:[Please Enter Your Report Title]

In the header of the report create a text box, in its properties ,data section set control source to Reptitle

 

[xlt-hunter]

That is brilliant, thanks Smart.

How do I get the query to repeat itself to gernerate extra rows of info.

I have "[Enter Ingredient Code]" in the criteria section on one column, this gives me a popup when starting the report to enter the code. I would like to have this reappear to enter more information. Maybe the action to with another pop up box like

"Would you like to add another ingredient"
"Yes" "No"

Click on yes and the query will rerun and enter the data in, select no and the report is made.

M