That is a little devil! Monkeyed with this for a bit and have a solution for you:
Flip the switchboard in design view and go to its VB module (code button on tool bar). Find the Function called HandleButtonClick and add this right after Const conCmdOpenPage = 9
Const conCmdOpenTheFormDatasheet = 666
Now add this right after DoCmd.OpenForm Rs![Argument], , , , acFormAdd
Case conCmdOpenTheFormDatasheet
DoCmd.OpenForm Rs![Argument], acFormDS
Now this forces the nasty thing to open in datasheet view!
Any form you want to do this to, you will have to go to the switchboard items table and in the field "Command" type 666.
If you want to do the same and have it open for additions only, repeat as above:
Const conCmdOpenTheFormDatasheet = 123
Case conCmdOpenTheFormDatasheetAdd
DoCmd.OpenForm Rs![Argument], acFormDS,,,acFormAdd
Same deal with the table but with the number...123
I don't know how the switchboard wizard will like this but what the h'. You do this, you are the switchboard manager!
Gord
ghubbell@total.net