OpenTable within a form

[tcb]

Is it possible to contain OpenTable or OpenQuery within an Access
form? Instead of in its own window?

Why do I want to do this?

I have a form that shows all of the fields, data types, descriptions,
etc. for individual tables. It's a database that documents a
database. From this form, for any given table, I would like to view
examples of the data by DoCmd.OpenTable. It would be nice if I could
have that within a form that I could size and put to the side, running
an on current method that would run OpenTable in that form as I go
from record to record.

 

[Douglas J. Steele]

AFAIK, it's not possible.

However, what you can try is to create a form (in continuous view) that has
as many text box controls on it as the maximum number of fields in any
table. Use that form as a subform on your existing form. Once you know the
table, set the RecordSource for the form being used as the subform and set
the ControlSource for as many fields as exist in that table (and set the
Visible property for the other text boxes to False)

You may want to check http://www.mvps.org/access/forms/frm0031.htm at "The
Access Web" if you're not familiar with referring to controls on forms being
used as subforms.

 

[Pieter Wijnen]

Or one subform for each table & toggling visibility etc

Pieter