Closing pop up forms after loading report

[dcjones]

Hi All.

I have look through the forum but can not find a solution to my problem.

I have a popup form set to "popup" and "modal" "frmJobBookOut" which passes data to a query "qryJobBookOut". In the query there is a field called "job_no" and I have set the criteria to reference the "frmJobBookOut" ** [forms]![frmJobBookout]![job_no] ** and a report "rptInvoice" based on the query "qryJobBookOuit". This all works fine.

The report loads with the popup "frmJobBookout" form still displayed. I know that the popup form is still displayed because I have the setting "modal" and until I click on the close button it will remain on screen.

Is there a way I can close the popup "frmJobBookOut" form after the report has loaded.

I have tried many ways but not the right way.

Many thanks if you can help.

Kind regards

 

[Rich]

Toggle its Visible property and then close it in the UnloadEvent of the Report

 

[dcjones]

Hi Rich,

Thanks, your right,

Post RESOLVED,

Many thanks