I have a form which is used to input a variety of items. Currently, I have embedded in that form an "Activity" table where I log chronologically information that comes in on the separate agreements created by the form. The Activity table is the child which makes the information directly relevant to the specific client being reviewed.
Instead of having the table appear on the form, I would like to be able to have a button on the form which would open the activity table when needed versus having it ever present on the form. I know the buttons when formatted will allow me to run reports, open forms, run queries, etc. but don't know if I can open a table that way.
Thanks.