I want to create a form that contains two subforms (one-to-many form).
So that if I change the number in the Record Number Box of Subform1, Subform2 will change automatically.
Thank you very much for your help! I truly appreciate it!
I want to create a form that contains two subforms (one-to-many form).
So that if I change the number in the Record Number Box of Subform1, Subform2 will change automatically.
Thank you very much for your help! I truly appreciate it!
You will need to do it manually, as the expected structure is form/subform. A couple of methods come to mind. Base the second subform on a query that gets a criteria from the first, and requery it in the current event of the first. Again in the current event of the first, set the record source of the second to an SQL statement that includes a criteria based on the first.