Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Open form in datasheet view 1

Status
Not open for further replies.
ptuck

ptuck

MIS
Aug 8, 2003
130
US
Why will my form not open in datasheet view when I use the openform command? The default view of the form is datasheet, but it always opens in single form. Please help.
 
Sort by date Sort by votes
Try using the acformds as view arguement:

[tt]docmd.openform "yourform",acFormDS[/tt]

Roy-Vidar
 
Upvote 0 Downvote
that worked perfect. I am not familiar with this command. I had tried them all, but this one. What does DS stand for (please don't tell me datasheet).
 
Upvote 0 Downvote
Since you ask, I don't know, but I've kind of assumed it was DataSheet;-)

Thanks for the star!

Roy-Vidar
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

caykamanj1966
  • Locked
  • Question
Duplicate Records in DataSheet View
Replies
5
Views
259
Andrzejek
Andrzejek
TinaS
  • Locked
  • Question
Quick one I think - question about Properties window in Form Design view
Replies
1
Views
100
dhookom
dhookom
TrekBiker
  • Locked
  • Question
Form Data Not Updating
Replies
6
Views
239
dhookom
dhookom
TrekBiker
  • Locked
  • Question
Forcing Form Updates
Replies
2
Views
195
TrekBiker
TrekBiker
breezett93
  • Locked
  • Question
Function that find all controls on a form and puts their tab index in numerical order
Replies
19
Views
363
dhookom
dhookom

Part and Inventory Search

Sponsor

Back
Top