Button to open a table!

[Bob]

How can I assign a button on my main menu to open a certain table, so I can
alter some data with out going through the from page
Thanks in advance.........Bob Vance

 

[fredg]

How can I assign a button on my main menu to open a certain table, so I can
alter some data with out going through the from page
Thanks in advance.........Bob Vance

DoCmd.OpenTable "TableName" will open a table.

However, you should NOT be altering data directly in a table.
Use a Form.
If you want the look of a table, open the form in datasheet view.

 

[Bob]

Is it Ok to add and delete from Datasheet View..Thanks Bob

 

[Bob]

Can I create a shortcut button on my form to Datasheet View? Thanks bob

Is it Ok to add and delete from Datasheet View..Thanks Bob

 

[fredg]

Can I create a shortcut button on my form to Datasheet View? Thanks bob

Is it Ok to add and delete from Datasheet View..Thanks Bob

Form Datasheet View?

DoCmd.OpenForm "FormName", acFormDS

 

[fredg]

Is it Ok to add and delete from Datasheet View..Thanks Bob

Form Datasheet View?
Sure.

 

[Bob]

Form Datasheet View?

DoCmd.OpenForm "FormName", acFormDS

Sorry where do I enter this code into the button.....Thanks bob

 

[Bob]

Sorry where do I enter this code into the button.....Thanks bob

GREAT worked it out Code Builder and then entered the frm name, BRILLIANT
Thanks.....Bob