modal options. my form open behind the form.

[Marco]

Hi. In the switchboad I have two buttons to open my FormA.

From Form A can open FormB.

Those two buttons in switchboard. has different methods to open FormA.

Button1 opens the form in Add mode.
Button2 opens the form in Edit mode with data.

In the FormA I can insert records in a table. After I insert a record on
FormA I press button that in there, called Button3.

When I press Button3 from FormA I open FormB.

My problem is that when I open FormA in Add mode the FormB opens behind
FormA but if I open FormA in Edit mode the FormB opens in Front/ onTop of
FormA.

What can I do to make FormB open in Top of FormA when I open FormA in Add
mode?

Thanks in advance,
Marco

 

[Jeanette Cunningham]

Marco,
Opening a form in acDialog mode puts the form on top.

DoCmd.OpenForm "FormName", , , , , acDialog

Jeanette Cunningham

 

[Marco]

Hi. Great Jeanette.

I didn't knew that. And that was the only code different from others. Nice.

Thanks,
Marco