open form in datasheet view

H

Heather

I have the default view set to datasheet and the following
on_open command:

DoCmd.OpenForm "yourForm", acFormDS

I get a run time error "you can't switch to a different
view at this time."

any suggestions?
 
A

Ashby

Your problem is confusing. If you already have the
default view set to datasheet, why are you trying to open
the form in datasheet view. This is very redundant. My
advise---lose the code.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Unremovable horizontal scroll bar on subform 1
Open a form in continuous form view 4
Datashhet View from another Form wont work 2
Form Default View - Datasheet 2
Changing the view. 4
Datasheet View 3
Command Button with datasheet view 3
Datasheet View 3

Top