Bring up table from a command button? 1

[BLutgen]

I have a end user who likes to use the main table to locate data. I am using a switchboard with command buttons for navigation. Is there a way to open the table from a command button? I didn't see it in the wizard, and am not yet real proficient at VB to know the command for it. Thanks in advance for the help.

Brad

 

[robmkimmons]

Brad,

Here is the code to put for the command button's "on click" property: (substituting the "YourTableName" with the table you wish to be opened... leaving the "" ).

Private Sub cmdOpenTable_Click()

DoCmd.OpenTable "YourTableName", acNormal, acEdit

End Sub


....hope that's what you need!
~Rob

 

[BLutgen]

Thanks a lot. That is exactly what I needed to know.

Brad