I have a form with subforms on it. The form "frmPWCTools" has the subforms "frmPWCInspections & "frmPWCDimensionVerficatio
n" on it.
The tables associated with it are: "tblTools", "tblInspections", and "tblDimensionVerification"
I have tested the tables and I can enter data into table "tblTools" and that data flows without fault to the other two tables.
My form "frmPWCTools" sees the data from the first child table "tblInspections" but not the second child table "tblDimensionVerification"
I used the wizard to create the form. I have looked at the example forms created for me by several individuals on EE yet I cannot seem to get it right. This is really bugging me what the heck am I doing wrong!!
Also if I try to add or change a record I get "You cannot add or change a record because a related record is required in table "tblInspections". This occurs when I try to enter measurements into last part of the form which sends data to the table "tblDimensionVerification"
If I go to the tables themselves I can enter data into all three tables when starting entries in table "tblTools". I don't get why the forms won't work. It doesn't see like it should be this hard unless I am that stupid.
I am working from home today. I am using Access 2010 I just got it. If I can get this db to work I will be able to work from home more often so I am hoping someone can show me what I am doing wrong.
I know how to create forms that only see certain tools and include host of other controls that members of EE have taught me how to do. Is too much being asked for a single form to do??
I can add a lot of controls to forms with what everyone has shown me but this one thing keeps stumping me.
The format of this form is what is being asked for. I will later have to add a results panel to the bottom of each form which shows the Min, Max, Range, Repeatablity, Accuracy, St Dev & Avg of the measurments taken.