hey Arizona , sup..
I take it you get this error when creating NEW records? It seems to work fine with the existing records you have inputted (is that even a word), .. hmm. Anyhow, the reason you get the error is because the Main form must be commited (saved) back to the table.
heres what I did to fix it, ..
Insert this event into all 3 of your subforms:
frmContractor_Eval_Section1
frmContractor_Eval_Section3
frmContractor_Eval_Section5
Private Sub Form_BeforeInsert(Cancel As Integer)
If Me.Parent.NewRecord Then
Cancel = True
MsgBox "Enter the main form record first."
End If
End Sub
and insert this event into your main form:
frmContractor_Evaluation
Private Sub Form_AfterInsert()
DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70
Me.frmContractor_Eval_Section1.Requery
Me.frmContractor_Eval_Section3.Requery
Me.frmContractor_Eval_Section5.Requery
End Sub