Datasheet view with a form and a sub form

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Kevin0862 - 12 Jul 2005 00:02 GMT

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.

Reply to this Message

Scott Vincent - 12 Jul 2005 01:58 GMT

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.

Signature

Happy Coding,

Scott

> 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,
[quoted text clipped - 9 lines]
>
> Thanks.

Reply to this Message