Button Problem

[Paul Cooke]

Hi Guys,

I have a form "details" with various personal fields the last one being EmailAddress. when this field loses the focus i have a macro that opens a popup form "choices". this form has two buttons on it "Save and Exit Form" and "Add New Record"

The add new record button works perfectly but the save and exit form wont work no matter what i am trying !

when i click it I get

"this action can't be carried out while processing a form or report... ect the macro action causeing this is CloseWindow.

I am lossed as to what to do to resooolve this so would appriciate any help you can offer.

Whilst writing this can I just ask an opinion on Macros vs Code would I be better off to use code to do this rather than using macros?

Many thanks

 

[Marinus]

Hi Guys,

I have a form "details" with various personal fields the last one being EmailAddress. when this field loses the focus i have a macro that opens a popup form "choices". this form has two buttons on it "Save and Exit Form" and "Add New Record"

The add new record button works perfectly but the save and exit form wont work no matter what i am trying !

when i click it I get

"this action can't be carried out while processing a form or report... ect the macro action causeing this is CloseWindow.

I am lossed as to what to do to resooolve this so would appriciate any help you can offer.

Whilst writing this can I just ask an opinion on Macros vs Code would I be better off to use code to do this rather than using macros?

Many thanks

I would put the buttons on the original form saves looking at another popup a further explanation would be useful... (in my case) . As far as Macros vs Code, and I am certainly no expert so don't count to much on my opinion, events are far more flexible and traceable. But again that is only my 2 pence worth..

 

[Paul Cooke]

thanks for the reply.. i do actually have the same buttons on the details form (and both do work) but they were put on it as a test the reasoning behind the pop up is to try and "force" the user to select something rather than clicking somewhere else on the form. I suppose I am trying to ensure that the user has to follow a set 'flow'

I am grateful for your opinon on macro's vs code !

 

[Marinus]

thanks for the reply.. i do actually have the same buttons on the details form (and both do work) but they were put on it as a test the reasoning behind the pop up is to try and "force" the user to select something rather than clicking somewhere else on the form. I suppose I am trying to ensure that the user has to follow a set 'flow'

I am grateful for your opinon on macro's vs code !

If you post the app I can have a look later on..

 

[Paul Cooke]

Thanks for the offer - I have just done it in code and its working fine now !

 

[Marinus]

Thanks for the offer - I have just done it in code and its working fine now !

Great, Be well and prosper..