Form from background to foreground

[nelbekri]

Hello,

I am working on a database during my internship using ms access 2007, and I have a problem managing two forms , form A and form B. The call to form B is done through form A, but then form B stays in the background and users don't see it because it's behind form A. I've tried SetFocus but it didn't work .
Any suggestions please.

 

[Uncle Gizmo]

If you go into the forms properties and set modal to yes and popup to yes I think it will come to the front.

 

[apr pillai]

Normally when a second form is open it opens over the first form.

It looks like your Form A has it Popup/Modal property set to Yes, so that it floats over all open forms.

Open Form A in design view and check the Popup & Modal property settings and change the value to NO.

 

[nelbekri]

Thank you guys for your answers. It worked, I set modal and pop up properties to No for the form A and it worked, when the call of form B is done it displays correctly and in the foreground.
Thank you very much