Compiler error: Method or member not found

[JosmithTwo]

I get "Compiler error: Method or member not found" on the rstSegments but not on rstAK9. Both reference simple tables. HELP! thanks

    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

[JosmithTwo]

Found it myself. rstSegments!CTXErrDescp = !field01 works. I'm still not sure why.

[John_G]

Hi -

It wasn't !Field01 that was generating the error - it was .CTX_ErrDescp. On your second example, you don't have the underscore character (i.e. !CTXErrDescp) and it works, which means that the field name in the rstSegments recordset is CTXErrDescp, not CTX_ErrDescp.

John

[JosmithTwo]

Wow! I'm impressed that you looked at the prior example. You're right in that the underscore was a problem, but with that corrected, it still demanded the "!".