Form Question

[KerryDee]

Hi I am using the Web template Services from Access 2016. I have a slight problem.

I am trying to the get the following to show up on in datasheet view however, it only happened when I select datasheet view. How do I view it in datasheet view so that when I add it to a button it pops up in datasheet view always. Thanks for your help.

I am attaching a document with the issue.

Thanks again.

KerryDee

 

[CJ_London]

I don't use web templates, but with 'normal' access forms you set the default form view in form properties to datasheet

 

[missinglinq]

How do I view it in datasheet view so that when I add it to a button it pops up in datasheet view always...

Know nothing about web templates, either, but if you're saying that you have a Command Button on one Form used to open a second Form, in Datasheet View, you have to set the FormView Parameter of the OpenForm command to acFormDS:

DoCmd.OpenForm "SecondaryFormName", acFormDS

if you don't use this setting, the secondary Form will not open in Datasheet View, even if the Default View is set to Datasheet View.

Linq ;0)>

 

[KerryDee]

I don't use web templates, but with 'normal' access forms you set the default form view in form properties to datasheet

Thank you very much for the response.

Kerry

 

[KerryDee]

Know nothing about web templates, either, but if you're saying that you have a Command Button on one Form used to open a second Form, in Datasheet View, you have to set the FormView Parameter of the OpenForm command to acFormDS:

DoCmd.OpenForm "SecondaryFormName", acFormDS

if you don't use this setting, the secondary Form will not open in Datasheet View, even if the Default View is set to Datasheet View.

Linq ;0)>

Thank you very much.

KerryDee