Opening a Form in Datasheet View You might find that this doesn't work even though the form has been set to have a Default View of Datasheet. this is because the syntax for opening a form is: DoCmd.OpenForm "frmName",View Now the View settings set here will override any set for the form itself, and View will default to acNormal if no argument is entered. Therefore, you will need to modify the code slightly: DoCmd.OpenForm "frmName",acFormDS Top   HOME | NEW | TABLES | QUERIES | FORMS | REPORTS | GENERAL | API | DOWNLOADS | TUTORIAL | RESOURCES E-MAIL Copyright & Disclaimer

Last modified at 06/06/2006 14:53:43