Opening Datasheet forms from Switchboard

  • Thread starter Bonni Rooney via AccessMonster.com
  • Start date
B

Bonni Rooney via AccessMonster.com

Hi, I recently had the problem with Switchboard Manager - none of my forms
would open in default Datasheet View. I tried about 6 different types of
codes to no avail - until I found one posted by Rob Oldfield? Sorry can't
find the thread now - Anyway - this one is BY FAR THE EASIEST and simplest!
It works!

You could edit the existing part saying...

' Open a form.
Case conCmdOpenFormBrowse
DoCmd.OpenForm rs![Argument]

to

' Open a form.
Case conCmdOpenFormBrowse
DoCmd.OpenForm rs![Argument],acformds
 
Top