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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Changing Form's View in VBA 1
Duplicate code consolidation 9
datasheet versus formview display mode 3
Close form button works in adNormal and not acFormDS view 5
Run-Time Error 1
Setting form view 2
Opening a form as datasheet and dialog will not pause code 1
datasheet view 2007 without saving column layout changes 2

Back
Top