The macros are runnig in the background of the form

[Trisha]

Dears,

I have develped few macros in ms access which are called via a form.

But everytime I click on the command button in the form to exécute the macro the macro open in the background of the form.

1. The macros open the existing table to add new records.
2.The form pou up and modal property has been set to yes.



could you please help how to bring the macros in front.

[NTC]

there seems to be a terminology issue; a macro is in essence a vehicle by which one triggers code. there is nothing visible necessarily to be seen in terms of the code doing its job. what the code does may create something visible to the user; and of course the macro itself as a design object can be seen in design view.

[Trisha]

Hi NTC,

Let me frame my question.

I have a form say Form 1

Form1 is having 3 command buttons to call 3 macros.

The Macro 1 open the table to add a new row.
Macro 1 is working fine but after exécution of Macro 1 the table opened in the background of the Form 1

[NTC]

add a macro line to SetFocus to the table object