open a table from within a form

K

Kim Doe

Is it possible to open a table from within a form? Via a comman
button?

I need to open a linked table from a form for the purpose of fillin
out info in the table related to said form record. The table contain
information over time for an individual.

I've tried just placing a subform, but I need the asthetic of th
entire table as opposed to a single record at a time.

TIA
 
A

Al Camp

Kim,
You said:
...purpose of filling out info in the table related to said form record.
Click to expand...

Not sure I understand... a "continuous" subform would show all records
"related" to the main form. Why would you want to see all the tables
records. Was your subform display "Single Form" when it should have been
"Continuous"?

A subform without any Parent/Child link would display all the records
from a table, but I'm woondering why you would want to do that...
Or... you can just do a DoCmd.OpenTable "tblYourTableName" to display all
the records in a table. It will cover up your form, but upon closing the
table, you'll return to your form.

Could you provide a bit more info as to why you want this arrangement?
hth
Al Camp
 
Top