I've played around with changing some of the variables, but the samthin happens.Any ideas?
The table being updated is a local one within the db.
Relevant code bits:
Expand|Select|Wrap|Line Numbers
- Dim CaseDetails As Recordset
- Set CaseDetails = CurrentDb.OpenRecordset("PathwayCases")
- CaseDetails.FindFirst "[NHS]='" & SaveNHS & "' AND [Referral]=" & SaveReferralRef
- CaseDetails.Edit