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

B

buddythebest

Registered User.

Local time

Today, 15:58

Joined

Mar 31, 2006

Messages

32

• Apr 6, 2006

• #1

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

 

ansentry

Access amateur

Local time

Today, 22:58

Joined

Jun 1, 2003

Messages

995

• Apr 6, 2006

• #2

DoCmd.OpenForm YourFormName, acFormDS

 

RuralGuy

AWF VIP

Local time

Today, 06:58

Joined

Jul 2, 2005

Messages

13,825

• Apr 6, 2006

• #3

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.

 

B

buddythebest

Registered User.

Local time

Today, 15:58

Joined

Mar 31, 2006

Messages

32

• Apr 7, 2006

• #4

thanks for the help...

 

B

buddythebest

Registered User.

Local time

Today, 15:58

Joined

Mar 31, 2006

Messages

32

• Apr 7, 2006

• #5

still doesnt work

 

B

buddythebest

Registered User.

Local time

Today, 15:58

Joined

Mar 31, 2006

Messages

32

• Apr 7, 2006

• #6

nevermind i just made it to open the query straight away... thanks for the help anyway.

 

neileg

AWF VIP

Local time

Today, 13:58

Joined

Dec 4, 2002

Messages

5,975

• Apr 7, 2006

• #7

I don't like datasheet view. I like showing the user a query even less. A continuous form would do just nicely.