Trying to Update database with Unbound field.

[hunterjj]

The following highlighted code(>>>>>>>>>>>>>>>>) gives me:
"operation is not supported for this type of object"

I'm assuming the Edit & Update will give me the same error.

I got this code from RickSpr in response to Swiftraven(May 9, 2002--Saving calculated valued in an archive table)

I'm using Access 2000.
In my VBA code, under Tools/Reference, I have the Microsoft DAO 3.6 Object Library checked.
Players is the database I'm trying to update.

Any ideas??

Dim PlayerInfo As DAO.Recordset
Set PlayerInfo = CurrentDb.OpenRecordset("Players&quot

'>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
PlayerInfo.FindFirst "PlastFirst = '" & svPlastFirst & "' "
'>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
If PlayerInfo.NoMatch Then
MsgBox "Can't find Player(" & svPlastFirst & &quot"
Etc.
Else
PlayerInfo.Edit
PlayerInfo![Field] = work
PlayerInfo.Update
End If

 

[hunterjj]

Never mind. I found an answer that would work when looking at the response to FoxProProgrammer May 13, 2002-->Update a record) by BanditLV May 13, 2002. There is just so much information on this site, it is all but impossible to search it all.