Recording a command button name

[E]

I have an application where the user is prompted to save when they leave the
the data entry form either by previewing a report of the data or by closing
the form completely. There are two buttons a user can use to do this
cmdPreview or cmdClose. I use a module to promt the user for svae. What I
would like to do is differentiate to the module which button was clicked. Is
there a way to do this?

thanks

 

[Douglas J. Steele]

You could take a look at

Screen.ActiveControl.Name

 

[E]

Thanks Doug. That did the trick.

You could take a look at

Screen.ActiveControl.Name


--
Doug Steele, Microsoft Access MVP
http://www.AccessMVP.com/DJSteele
(no e-mails, please!)




.