Hiding/Showing Form

[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.

 

[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.

 

[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.

 

[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.

 

[James Nap]

I am going to work on building a dynamic form. Thanks.