How to by pass CLOSE event? (97)

Topic

New Reply

How to by pass CLOSE event?
My report deletes a toolbar whenever the report is closed however, I have an option to re-query the report date in order to

Reply | Quote

Replies

Why deleting a toolbar ?
In the On Close event of the report you can use :
DoCmd.ShowToolbar “YourToolBarName”, acToolbarNo
In the On Open event of the report use :
DoCmd.ShowToolbar “YourToolBarName”, acToolbarYes

Reply | Quote

Well as of my post I didn

Reply | Quote

Hehe

Reply | Quote

It’s even possible without using code:

Forms and reports have a Toolbar property. By clicking in this property and selecting the name of a custom toolbar, you “bind” the toolbar to the form/report. This means that the toolbar will be displayed automatically when the form/report is opened and hidden when the form/report is closed. The standard Access toolbar for forms/reports will be *not* be shown.

Reply | Quote

Muchos gracias, excellente seniorata (THE SIMPSONS)

Reply | Quote