How to openforms in datasheet view?

[Bisleycat2002]

I'm a bit of an access novice and I want to open a form in "datasheet view" from my switchboard. I used the wizard to create the switchboard and it insists on opening the form in "form view". I've disabled the "form view" property on the form but this is being overridden by the openform command on the switchboard (I think!) - help please?

 

[Andrew Fergus]

Hi

Yes the (wizard) macro behind the button is over-riding the default views that you have set up for the form.

You can change this by doing the following :

Open the switchboard form in design view, Right click on the button you are trying to change -> Properties -> Event -> move down to On Click (where it should have [Event Procedure] -> click on the three dots to the right of the drop down arrow (on the same row).

You should now see the VB code behind the button. Locate the line that says something like :

DoCmd.OpenForm stDocName, , , stLinkCriteria {yours may appear to be slightly different}

and change it to something like this (by inserting the "acFormDS" after the first comma, without the quotes, but keep everything else the same) :

DoCmd.OpenForm stDocName, acFormDS, , stLinkCriteria

Save (the form and module) and close out of Microsoft Visual Basic. This should do the trick.

HTH, Andrew.

 

[Bisleycat2002]

Thanks - good answer