I get "Compiler error: Method or member not found" on the rstSegments but not on rstAK9. Both reference simple tables. HELP! thanks
Code:
Dim rstIN, rstHeader, rstIK5, rstAK9, rstSegments As Recordset
Set rstAK9 = db.OpenRecordset("tbl_999_040_AK9")
Set rstSegments = db.OpenRecordset("tbl_999_020_ErrSegments")
Case "CTX"
rstSegments.AddNew
rstSegments.CTX_ErrDescp = !field01 '<<err here
'Compiler error: Method or member not found
rstSegments.Update
Case "AK9"
rstAK9.AddNew
rstAK9.ID_file = xID
rstAK9.ID_Set = xAK2Ctl
rstAK9.AK9_ErrCd = !field01 <<No err here
rstAK9.Update