I think You are not using access the way it is designed to be.
Don't use query to insert records. Rather save the value to the bound controls.
If both the forms are linked , then create an update button on the parent form.
in the click event vba code ,
Refer to the controls in subform...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.