form opens but in background ?

  • Thread starter Thread starter David
  • Start date Start date
D

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?
 
This can happen if the current form has its Modal or Popup property set to
Yes, or if the table is already open.
 
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
 
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
 
Back
Top