Datasheet view with a form and a sub form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm currently having problems coding my form to show in datasheet view
format. I've made changes to Default Views and Views Allowed to Datasheet,
but it still will not take. When I code the form as indicated below:

DoCmd.OpenForm "Report Date Range", acFormDS, , , acFormEdit, acDialog,
"Reasons for Past Due Cases not meeting TA"

It will not allow the form to open up. I get an error. because of the
"acFormDS"

Can someone assist me?

Thanks.
 
I think your problem is with trying to open a form in DataSheet view and
Dialog Mode at the same time. Try wraping this form in another form. Create
a parent form with a subform. It will probably look better as well.
 
Back
Top