I am trying to create/enter records in my access database with a parent child relationship. I have several unbound subforms. Each subform reprents rating for the corresponding section (Category).
I do not want to create one subform and link it to the parent form and let access handle the recording/editing of records.
I would like to accomplish this through ADO recordset when entering records and viewing them by selecting a user name from a combo box on the parent form. Each user will be evaluated on specific catgory. I just don't know how to accomplish this through VBA. I don;t know how access allows you to enter records in the Child Table through the form-subform linked though the primary key and foriegn key. I think one should be able to accomplish the same thing through VBA? Does anyone have any example that uses unbound form within a parent form that users VBA to add and view records? Is it possible? I hope I was clear with my question
Any help will be greatly appreciated
Thank you
Parygoal
I do not want to create one subform and link it to the parent form and let access handle the recording/editing of records.
I would like to accomplish this through ADO recordset when entering records and viewing them by selecting a user name from a combo box on the parent form. Each user will be evaluated on specific catgory. I just don't know how to accomplish this through VBA. I don;t know how access allows you to enter records in the Child Table through the form-subform linked though the primary key and foriegn key. I think one should be able to accomplish the same thing through VBA? Does anyone have any example that uses unbound form within a parent form that users VBA to add and view records? Is it possible? I hope I was clear with my question
Any help will be greatly appreciated
Thank you
Parygoal
