I want button on a form to print specific report and the record is the same as form's record.
I want button on a form to print specific report and the record is the same as form's record.
If your form is Single Form view and you want to print a single record, the current record, the following should work if the field used as criteria is a number.
DoCmd.OpenReport strDocName, acViewNormal, , "[FieldName] =" & Me![FieldName]
thanks alot![]()