assigning command buttons to open tables?

[qweasd]

Hi,
i am currently trying to assign command buttons on my form (access 2000) to link to and open a table in my database. The wizard doesnt let you do this, its limited to linking to other forms, queries, etc. only.
Could anyone tell me the VB code for assigning a buttons to open a table please? if the table is called table1 lets say.
any help is appreciated, thanks.

 

[spacepro]

Put this code on the onclick event:

Docmd.opentable "table1", acviewnormal


HTH
Andy

 

[qweasd]

thanks very very much mate, it worked.

 

[spacepro]

Of course it Worked.
No problem, happy to help.

Andy