Taking more clicks to run a macro

[NaveenNandigam]

Hi, I am new to Access and I have created a macro and assigned it to a button on a form. When I update that form and hit that command button it not running the macro immediately. It is taking atleast 5-6 clicks to run that macro. Can anyone tell me how to correct this error.

Thank You,
Naveen

 

[FoFa]

What does the macro do?
What does the form do during this "update"?

 

[NaveenNandigam]

Hi FoFa, The form updates the information about a trailer and as we click the command button, macro opens two queries(Append and Delete) and closes the form. Now it running if I click the command button twice. Moreover, Macro runs fine when I tried it directly from a database. Hope you could help me.

Thanks
Naveen