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