KaylaHansa
New member
- Local time
- Yesterday, 19:59
- Joined
- Mar 22, 2020
- Messages
- 18
I have a main form which contains a related subform (one to many). I also have another separate form containing fields from the before mentioned subform, designed to be a dialog that is Data Entry only. I have a button on the main form. How do I program it's on click event to open the dialog form and allows the user to enter in a new record, while still maintaining the relationship to the main table? (For example, the main form would be "Customer" and the dialog form would be to "add a new system to customer".) I tried doing it with macros but it will lose the relationship with the current record on the main form, requiring the user to manually enter the ID of the customer to which they are trying to add the new system.