Form Design Help

[jimd1768]

I have a datasheet that I want to include on a form. I would like the form to look like the datasheet and not just single entries. I have attached a sample from Northwind to explain how I would like the form to look.

If anyone can offer any help I would be greatly appreciative.

Thank you

 

[KenHigg]

Set the form default view property to datasheet?

 

[jimd1768]

Set the form default view property to datasheet?

Hi Ken, Thanks for your response. This doesn't seem to work. Looking at the properties on the Northwind Form, it seems they use a split form. Would this be the option to use?

 

[KenHigg]

If it's not a datasheet view then it must be a subform in continuous view maybe with a header section enabled

 

[shadowmaster]

u can do this by VBA code

DoCmd.OpenForm stDocName, acFormDS, , stLinkCriteria