>In the design view of the form I create three different button that will open
>the table, however when i try to open each table it seems that it is all
>opening same table
Well, then presumably that's what your button code is asking Access to
do. Care to post the Click event code belonging to each button? YOU
can see your database; we cannot, and have no way to tell what your
buttons might be doing.
One question: Why open a Table, AT ALL? Table datasheets are generally
*not* suitable for interacting with data. What are you trying to
accomplish?
John W. Vinson[MVP]