Aug 16 2006, 10:20 AM
I'm having trouble opening a form in datasheet view from the Switchboard. The form's default view is datasheet, yet when I open it from the Switchboard it shows a single form. Any way around this?
Aug 16 2006, 10:23 AM
if the switchboard was created with the switchboard manager it has a tendency to overwrite the settings.
Use code to open the form instead e.g.:
DoCmd.OpenForm "frmMyForm", acFormDS
You can put that into a function in a new module and assign this function to be called in the switchboard manager if you re-run it.