Form stays in front when Table opens

[David Ball]

Hi,

I have a Form with a control button that opens a Table using VBA code.

I have made quite a few similar databases before and usually when the Table opens it opens "above' or in front of the Form.

This time the Table opens but behind the Form.

I would like the Table to open and appear in front of the Form.

Is there a setting or something to control which displays on top?

Thank you very much

Dave

 

[Galaxiom]

Users should not see the tables.

Create a datasheet form based on the table and open that instead. This will give you the SetFocus method to bring it to the front.

SetFocus isn't available on tables because they are not intended for display.

 

[vbaInet]

And once you've done what Galaxiom advised, remember to check the Pop Up and Modal properties of the form it was opening behind.