[AccessD] Method or Data Member Not Found

Rocky Smolin at Beach Access Software rockysmolin at bchacc.com
Wed May 14 13:05:16 CDT 2008


Dear List:
 
I'm getting a compile error "Method or Data Member Not Found" on the
variable MatterActionID  in a line of code which reads:
 
        Set rstMatterActionPersons = db.OpenRecordset("SELECT
MatterActionID, PersonID, " _
            & "Hours, SortOrder FROM MatterActionPersons WHERE
MatterActionID = " _
            & rstMatterAction!MatterActionID & " AND " _
            & "(PersonID = " & lngOldAttyMatter & " OR PersonID = " &
Me.AttyMatter.Column(0) & ")")

rstMatterAction is set with:
 
    Set rstMatterAction = db.OpenRecordset("SELECT Matters.MatterID, " _
        & "MatterActions.MatterActionID, MatterActions.Complete FROM Matters
" _
        & "INNER JOIN MatterActions ON Matters.MatterID =
MatterActions.MatterID " _
        & "WHERE Matters.MatterID = " & rstMatters!MatterID _
        & " And MatterActions.Complete = False " _
        & "ORDER BY MatterActions.MatterActionID;")

so you can see that rstMatterAction!MatterActionID is included in the
MatterAction recordset.  This code compiles in another module.  So I think
that the Data Member Not Found is due to something else.  
 
Any ideas?
 
MTIA
 
Rocky
 



More information about the AccessD mailing list