I want datasheet view... why does it keep showing form view?

buddythebest

Registered User.
Local time
Today, 21:55
Joined
Mar 31, 2006
Messages
32
I have a form which is opened with a filter from another form. For some reason it views the form in form view, although it was set up as datasheet view. I even went to the form properties and the default was datasheet and i made it not to allow other views. This still didnt solve it. I want it to be in datasheet view because i want to show multiple records at the same time.

If u kno how i could resolve this please offer ur help

thanks
 
DoCmd.OpenForm YourFormName, acFormDS
 
From VBA Help:
expression.OpenForm(FormName, View, FilterName, WhereCondition, DataMode, WindowMode, OpenArgs)

The View argument should be acFormDS to open the form in DataSheet format.
 
nevermind i just made it to open the query straight away... thanks for the help anyway.
 
I don't like datasheet view. I like showing the user a query even less. A continuous form would do just nicely.
 

Users who are viewing this thread

Back
Top Bottom