Findfirst/Edit problem

[redman08]

I'm trying to update a table, but when I get to the ".edit" line in my coding, I get the error message: "Run-time error 3251 - Operation is not supported for this type of object"

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:

 Dim CaseDetails As Recordset
Set CaseDetails = CurrentDb.OpenRecordset("PathwayCases")
 
CaseDetails.FindFirst "[NHS]='" & SaveNHS & "' AND [Referral]=" & SaveReferralRef
 
CaseDetails.Edit

[RuralGuy]

Did you find anything with the .FindFirst? If Not CaseDetails.NoMatch Then

[redman08]

I found, somewhere on the net that it might be because of the OpenRecordset statement. I have now changed it to:

Set CaseDetails = CurrentDb.OpenRecordset("Pathway Cases", dbOpenDynaset)

Now I'm getting a different error.The data should match, (in fact CaseDetails.NoMatch = False when running).

Now I am getting: "The Microsoft Office Access databse engine does not recognize 'Referral' as a valid field name or expression." (which is daft because 'Referral' is a valid column name for the table).

What do you think?

[redman08]

Panic over. Spotted my deliberate mistake with the column names. Thanks for you help, anyway.

Problem solved!