Problem with form opening from onclick

Posted on 2006-06-08
Medium Priority
Last Modified: 2008-02-01
I have a form that has a button and when I click on it the form opens but it's in form view.  I need it in datasheet view.

I've set the default to data sheet and even changed the settings for form view isn't available.  Any ideas why this thing keeps opening in form view?  Below is a way that another guy explained it...

"Won't open form in Data Sheet View - Access does not seem to allow you to open a form in Data Sheet View from within another form (in Form View) via a button - even though Data Sheet view is specified as Default in the properties of the form itself.  I have even tried to remove the "Form View" from the properties ("Allow Form View - "NO"") window - this has no effect when opening form from within another form.  Even from a switchboard it opens the form in "FORM" view not data sheet view.  You can switch the view on the form to Data Sheet once open but it will not open in Data Sheet view as a default"

So, the bottom line is why in the world won't the form open in datasheet view when we open it with a button.  When we open it from the access "console" (in the forms part) it opens in datasheet view every time.

Question by:ajslentz
  • 2
LVL 65

Expert Comment

ID: 16861042
u can specify the open in datasheet view when u open the form using


LVL 65

Accepted Solution

rockiroads earned 1000 total points
ID: 16861052
I think its Docmd.openform "form", acformds


Expert Comment

ID: 24421289
I just had the same issue a found another solution.
1. Right-click the button that opens the form and select "Build Event".
2. On the Action "OpenForm" and under the Action Arguments change the View from "Form" to "Datasheet"

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

The Windows Phone Theme Colours is a tight, powerful, and well balanced palette. This tiny Access application makes it a snap to select and pick a value. And it doubles as an intro to implementing WithEvents, one of Access' hidden gems.
If you’re using QODBC to update QuickBooks data from Microsoft® Access but Access is not showing the updated data, you could have set up QODBC incorrectly.
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…
With just a little bit of  SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form.  If you have never written code or looked at an SQL statement before, no problem! ...  give i…
Suggested Courses

850 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question