View Full Version : Opening up tables from forms


grayth
07-10-2001, 06:44 PM
Is it possible and if so how do I access some tables from a form via a command button?

This isn't covered in the wizard as I can only chose another form but some of my tables are easier to manage in tables but I would like to access them from forms. Is this possible?

charityg
07-11-2001, 09:46 AM
You have two options.

Use
docmd.OpenTable "tblName"
put this in the onclick event of the button you want to use to open the table.

OR

You can create a form and use datasheet view for a table-like quality.

HTH
Charity