MS Access FindFirst method issue...
Posted on 2003-11-20
Given the followinfg code:
rsChurches.FindFirst "[ChurchID] = ChurchID"
If rsChurches.NoMatch Then
MsgBox ("Error in updating Churches record for < " & ChurchID & " >")
rsChurches!SeniorPastorID = SeniorPastorID
rsChurches!YouthLeaderID = YouthLeaderID
rsChurches!YALeaderID = YALeaderID
rsChurches!MusicLeaderID = MusicLeaderID
rsChurches!MinisterialAllianceID = MinisterialAllianceID
rsChurches!AffiliationID = AffiliationID
rsChurches!ChurchDenominationID = ChurchDenomID
The Churches record has been previously created, and the FindFirst method supposedly finds the right record, but the Update seems to ALWAYS update the first record in the recordset. The documentation says that FindFirst makes the record found the current record, so what gives??