I do not know if a macro can do this or VBA is necessary. I have a command button in one form (formA) in which I would like to print using another form (formB). FormA is what the clerks inputting the data use but this same data is used in a printed form that is used as a cover sheet.
Using a macro, when I open FormB and print the selection, the record comes up to the first record and not the current one to print. Before I abandon the macro, I thought I would obtain a second opinion.