Form and table display

[Gizmo_TD]

Hi, I'm new to the site and in need of a bit of help.

I'm currently building a project and have a form that, on a click command, opens a table (uses the docmd.opentable). How can I change the focus so that the form does not display over the table?

TIA

 

[Jeanette Cunningham]

Opening a table is not recommended, instead build a form based on that table (create a query on the table and use the query as the record source for the form) and open the form instead.
Forms offer many possibilities to allow editing of data that tables lack.

 

[Gizmo_TD]

Thank you for your reply.

I don't really need to do any data editing to it, just need to view the table to copy the data out to another document (I could export table but don't really need it saved out each time). I guess my question is whether it's possible to hide the form and put in an "on close" command to restore it when I close down the table view?

 

[Jeanette Cunningham]

You can put buttons and code on forms, but you can't do that with tables and queries.
Perhaps the easiest way is to simply click on the table to bring it in front of the form.

 

[Gizmo_TD]

Apologies, never got around to thanking you for your help on this, I've got it exporting the information now rather than displaying it on the screen!