form opens but in background ?

[David]

I do an opentable command from a tabbed form event
procedure but when the table opens in datasheet view its
behind the current window and I can't get to it.
What causes this?

 

[Allen Browne]

This can happen if the current form has its Modal or Popup property set to
Yes, or if the table is already open.

 

[David]

Thanks for the reply.
I set both those properties to NO and I still have the
same problem. The table is not already open.
Is there some other way to do this?
I have a tabbed form and one of the tabs allows editing of
multiple tables. I do this by opening each table in
datasheet view.
- David

 

[Allen Browne]

In any application where you need to control how the interface works, it is
worth creating a form instead of letting the user edit the table directly.
If you set the form to Datasheet view, it can look the same as a table if
that's what you want.

After creating a form, the code to open the form in datasheet view and give
it focus would be:
DoCmd.OpenForm "MyForm", acFormDS
Forms("MyForm").SetFocus