One to many form-subform in Datasheet view

[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.