parameter prompt twice when opening report 1

[pandapark]

I'm trying to open a report as follows

SelYear = Len(Forms!frmRISKreports!List127.Column(1))
strCheck = Forms!frmRISKreports!List127.Column(1)
strFilter = Mid(strCheck, 1, SelYear)

DoCmd.OpenReport "rptAUDITRisks", acViewPreview

Reports!rptAUDITRisks.Filter = strFilter
Reports!rptAUDITRisks.FilterOn = True

works fine except I'd like to have a parameter whereby the user can add a title to the report. i've tried including it in as a column query i.e. Title: [Enter a Report Title]
I've tried having a text box with a control source of
Enter a Report Title
every method I try I get prompted twice for the parameter

any ideas much appreciated
thanks

george

 

[BSman]

Call the report from a form that includes a text box where the user enters the title.

On your report, the control (txtTitle) with the title should use the value in the form's text box. Just right click the source property for txtTitle, select Build, and then select the form and the text box control on the form.