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