Thanks anyhelp would be appreciated.

Regards

Keith

Hi Keith,

The best way would be to use a subview instead of a subform to display the message with the Yes, No & Cancel buttons. You then configure your Form to open the subview when required, and on the Form you will have to structure a rule (On Subview - (On View, when Delete Button is Clicked) subview, when Yes Button is Clicked)

which will access the subview and and set a text box to a value on you main view depending on which selection was made on the subview.

I have attached a package called "Keith Package.kspx" to this post which demonstrates the exact outcome you require. Please use Package and Deployment to deply this package.

Package use Instruction:

Enter an ID and load, then click delete and choose yes, no or cancel on the subview. you will notice that depending on your selection made the Response text box will be poulated and only on the Yes click will the record be deleted.

Kind Regards,

Raymond

Thanks RaymondJVR, you sent me in the right direction.

From your previous response I thought I wonder If  there is an event rule for a Subform that would do the same as your SubView Rule and sure enough there was.

I found the following rule that I have put on my Mainform. 

'When a control on a subform raises an event'

and I just use a simple 'Transfer Data' rule to assign a hidden control on my form to YES, NO or CANCEL 

which I can test. I will clear this label before I load the Subform.

Then just clos the subform.

Thanks again 

Keith