Full Version: Can't open form in datasheet view from Switchboard
UtterAccess Discussion Forums > Microsoft® Access > Access Forms
DerekC
Good Morning,

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?
freakazeud
Hi,
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.
HTH
Good luck
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.