help with report saving

M

mhmaid

hi
i have a report " Patients list" wich is based on a query where i have to
enter parameter ( Dates from and to) to view or print the report . what i
need is , on close of the report preview to prompt me wheather i want to sent
to file or not . if yes to sent to file as .
 
N

Neil

You should be able to put some simple VBA code in the 'On close' event for
the report that traps the closing of the report, however, you haven't given
us much information to go on as to what you want to do with the report if
'Yes' is selceted.

Neil
www.nwarwick.co.uk
 
M

mhmaid

thanks neil
actually , if yes is selected i want to save the report in my documents
folder as a snapshot format , to be able to open in future and also to be
able to email to any concerned staff.
 
Top