By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,570 Members | 1,646 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,570 IT Pros & Developers. It's quick & easy.

Open a table from switchboard to enter data

P: 5
I want to open a table from switchboard in datasheet view to enter data, can anyone please guide me how it can be done, i created a form for the table and tried to open it from switchboard but it does not open in datasheet view.

I am a newbie so any help is appreciated....
Mar 7 '10 #1
Share this Question
Share on Google+
3 Replies

Expert 100+
P: 1,134
in the code that opens the form you need something like this
Expand|Select|Wrap|Line Numbers
  1. docmd.OpenForm "form Name",acFormDS
Mar 8 '10 #2

Expert Mod 15k+
P: 31,769
If it's the table you need then something like :
Expand|Select|Wrap|Line Numbers
  1. Call DoCmd.OpenTable("TableName", acViewNormal, acEdit)
Mar 8 '10 #3

P: 106

How about this code:
Expand|Select|Wrap|Line Numbers
  1. DoCmd.OpenForm "FormName", acFormDS
Sorry I did not see the solution above.. Apologies.
Mar 10 '10 #4

Post your reply

Sign in to post your reply or Sign up for a free account.