Unanswered: Print/Preview report for current record, unwanted parameter box.
Have a button on a form set to preview a report for the current record on the form. Simple enough I thought !
When I click the button instead of the report preview a parameter box comes up for the field ( NI ) that I’m using to specify for the current record. Weirdly the actual parameter for the current record appears in the title bar of this parameter box, if I then type this parameter in to the box the record is then previewed .
I’ve used the same code ( with the form/report references amended of course) in a different database and it works fine ie no parameter box.
I’ve tried setting up a new report ( a few actually) in this database to preview but get the same parameter box.
Any advice suggestions please ?
Code for button is as follows
Private Sub Print_Training_Record_Click()
On Error GoTo Err_Print_Training_Record_Click
Brilliant Paul , worked perfectly. If you have the time could you please explain what the problem was and why the addition of & "'" sorted it, ie what is the & "'" doing. I'm going to add some other report buttons and will presumably have to add this again so would like to know what I'm doing !
This forum is brilliant , wish I'd come across it months ago !