One to many form-subform in Datasheet view (1 Viewer)

[Wysy]

Hi, i am looking for something where i am not really sure about the wording.
I would like to have a form in datasheet view listing records. While cliking on a record i would like to have a subform opened under the records (like in case of the tables with one-to-many relations). Is this possible in access?
thank you

 

[June7]

Sort of.

Can set forms to display as datasheet and subdatasheet. I've never used this setup. I think it is confusing to users. https://support.microsoft.com/en-us/office/create-a-form-by-using-the-form-tool-f30f9c46-ca7c-4020-aaa7-f64045fca0fd#:~:text=On the Home tab, in the Views group,,is based on the related table or query

https://www.access-programmers.co.uk/forums/threads/insert-subdatasheet-for-forms.68468/

 

[Wysy]

Thank you! This helped a lot.

 

[Pat Hartman]

I wouldn't use the subdata sheet. I think it is very confusing to look at. A better interface would be to use the double click event of some control and open a popup form that shows the related records. If you also want to use this popup for data entry, remember that YOU MUST populate the FK because Access isn't going to do it for you. Use the BeforeInsert event to populate the FK.