Won't open in datasheet view from switchboard

[Huddle]

I can't get my form to default to the datasheet view from the switchboard so I was going to do an "on load" with the below code but it is not working. Can you let me know what I am missing?



Private Sub Form_Load()
Me.Visible = False
stDocName = "Fm_Schedule_Quick_Glance"
Me.Visible = False
DoCmd.OpenForm stDocName, acFormDS, , , , acDialog
DoCmd.Restore
Me.Visible = True

End Sub

[June7]

If the form DefaultView property is set to Datasheet and the AllowDatasheet property is set to yes, then the form should open in Datasheet unless code overrides these settings.

Want to provide db for analysis? Follow instructions at bottom of my post.

[Huddle]

The defaultview is datasheet and the allowdatasheet is yes. The issue I feel is that it is being opened from a switchboard in edit mode and it is overriding the default. That is why I wanted to put in the code. I can not provide the database for analysis.

[June7]

What do you mean by 'edit mode'? Why would this prevent DatasheetView?

If you can't provide db, doubt can be helpful. Don't care about data, just structure.

[Huddle]

If you open in the Quick Glance Form you get the datasheet view. If you open from the Switchboard you get an error due to the bad code. Database2.zip

[June7]

Crud! Just as I was afraid of. The switchboard was built with wizard and uses embedded macros. Macros is one reason I don't use wizards - I don't use macros, only VBA. And have never utilized a 'switchboard' - I build menu forms from scratch and use VBA for code.

Load event VBA procedure behind the opening form triggers error message #2174 'You can't switch to a different view at this time.', which actually makes sense. Can't have code behind a form to open itself. I tried to programmatically set the DefaultView property but that is not possible.

View this thread on the topic http://bytes.com/topic/access/answer...er-form-opened
The reply by FishVal might resolve your issue.

I think it's an inherent bug in macros. Unless specified otherwise in the macro, the OpenForm will override form defaults and open form in SingleView.