Pop Up Table Via Form Button Press Or Hide Form But Make Form Visible Again When Tabl

[StanJx]

Hi,

In my access database I have created an Admin portal (which is restricted to users) so the system admin could view the table data. Since my form is a pop up and I have disabled control box and control buttons on the form. I was wondering if there was a way to get the table to pop up in front of the form. Or the form hides and once the table is closed it becomes visible again. Any thoughts??

Appreciate your quick response.
Thanks in Advance
Stan

 

[JHB]

Put the table in a form or even better, when the system admin login disable the form's popup function.

 

[StanJx]

I used a form in datasheet view. and used sub forms to show relationships Just what I needed thanks.