Sub Form

[Keith Hawes]

Can I show a Subform in datasheet view when master form is in datasheet view. It works ok whwn master form is in singlesheet.
keith hawes

 

[wazz]

sure, just make the parent and the child default to datasheet view. you won't see the child records though until you click on a plus sign on the left side of the main datasheet.

 

[Keith Hawes]

Hi wazz thank you for your response. What you said does work but as we will be entering quite a bit of data quickly I wanted the subform to appear without having to press the + button every time. Also you then have to click the - button to close it . Is it possible to automate this feature.

 

[wazz]

when the main form opens you can automatically expand the subdatasheet with:

DoCmd.RunCommand acCmdSubdatasheetExpandAll

this will expand all the records. doubt if you want that but it could serve your purpose. you can then tab through everything. i was working on doing more than that (automated) but ran in to an error that i can't quickly get a fix for. hth.