Need Help with the Common dialog control 1

[RickBerem]

Hi,
In an Access 97 vba code, I use a common dialog to show the "printer" screen where my users can select the printer they want to print their reports. my problem is that I can't handle the situation where the user presses the CANCEL button on the "printer" form shown by the common dialog control.

is there a way to do that?

thanks

RickBerem

 

[TomB]

Set the CancelError property of the Common Dialog to True. It will raise an error when the user clicks on cancel and you can handle it with the err Object.


cdlg.CancelError = True
On Error Resume Next
cdlg.ShowPrinter
If Err.Number = 32755 Then MsgBox ("Cancel&quot

If everything was ok the err.number is 0. Any other number is another error. (Try err.description)

CU
Thomas

 

[RickBerem]

Perfect... Exactly what I wanted thanks.