Report Preview

[Radach]

I have a main form frmCustomers and a subform frmInvoices. One to many relationship - One customer can have many invoices.

I have a command button cmdPreivew which allows to preview the invoice and then print if they chose to do so. When I click on the command button it opens up the report. When I close the report it reverts back to the first record of the main form.

Is there something that I can do to prevent that. I don't want it reverting back to the first record. I want it where when I close the report it'll still have the same record that I was on.

 

[Oldsoftboss]

There must be a requery or something resetting the form. After opening your report, move it out of the road and see which record is displayed on the form, then watch the form as you close the report.

 

[Radach]

Thank you! That was it. I inherited this database and there was a me.requery on the form's on activate event.

 

[Oldsoftboss]

Glad to help