Hiding/Showing Form


J

James Nap

I have a popup form with a control button on it that opens
a table in normal view, i.e.
Docmd.OpenTable "tablename", acViewNormal, acReadOnly
However because it is a popup form the table is hidden
behind the form. I use the Me.Visible = False command to
hide the form before openning the table but I am having
trouble trying to display the form again after the table
is closed. I do not know or see a "close event" for the
table. Thanks.
 
Ad

Advertisements

K

Ken Snell [MVP]

Tables in ACCESS have no events. You should not be displaying the actual
table; rather you should display a form that is bound to that table and let
the form display the data. Then you can use the Close event of the form to
make your popup form visible.
 
J

James Nap

The problem with that is their are different tables with
different fields and new tables constantly being added.
The form would have to be dynamic to handle the different
tables.
 
K

Ken Snell [MVP]

If you say that you must display the table itself, then I know of no way to
have the table trigger the reappearance of the hidden form. The only
roundabout way would be to have the hidden form have code constantly running
on its Timer event that would check to see if the table (you'd need to know
the name of the table) is being displayed and if not to then make the hidden
form reappear.
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top