Datasheet view from Toolbar/Menubar - Access 2003

[lshores]

I have a form with a default set to Datasheet, Allow Datasheet set to yes and the rest set to no. This form is opened from a toolbar and opens in datasheet view (which is what I would expect). If pressed again to access it (when it is still open) it changes to form view, despite the fact that form view is set to no. You then cannot get back to datasheet. Any help would be appreciated

 

[ghudson]

Not sure how you are opening the form but this will force the form to be opened in the datasheet view...

DoCmd.OpenForm "YourFormNameHere", acFormDS, "", "", , acNormal

 

[snoko]

GHudson,

If a form is being opened from a toolbar, you cannot see or alter, as far as I'm aware, the code that access uses to open the form. The fact that you can open the form in datasheet view by clicking the button and then when you click the button again, as a user might do, the form opens in form view and will not return to datasheet view seems unique to Access 2003 as it doesn't happen in A97.

This occurs even if all the properties on the form are set to only allow datasheet view.