RickHunter84
Registered User.
- Local time
- Yesterday, 21:11
- Joined
- Dec 28, 2019
- Messages
- 85
Hello there,
I hope everyone is doing well.
I've been trying to find a work around to add a record into a sub-form that is not by direct input into the sub-form, for example: I have the Main form that has the ID (autonumber), the sub-form is related via the MainID (ID_FK) and it has is own SubID.
The Vision: I want to have a pop-up window that is unbound, validate the user entry and then after validation, insert the data into the sub-form table. the sub-form is bound to a query that requeries once the popup form closes. The idea is to requery the form with each new entry, so the user can see previous entries.
The current situation: This works only when the main form is set to "Data entry: No" - when switched to Data entry: Yes - it doesn't work (Insert into doesn't add new information into table from sub-form).
Any thoughts on how to work around this issue?
thank you in advance.
Rick
I hope everyone is doing well.
I've been trying to find a work around to add a record into a sub-form that is not by direct input into the sub-form, for example: I have the Main form that has the ID (autonumber), the sub-form is related via the MainID (ID_FK) and it has is own SubID.
The Vision: I want to have a pop-up window that is unbound, validate the user entry and then after validation, insert the data into the sub-form table. the sub-form is bound to a query that requeries once the popup form closes. The idea is to requery the form with each new entry, so the user can see previous entries.
The current situation: This works only when the main form is set to "Data entry: No" - when switched to Data entry: Yes - it doesn't work (Insert into doesn't add new information into table from sub-form).
Any thoughts on how to work around this issue?
thank you in advance.
Rick