Recordset.Update produces application crash

[chappy72]

Hello everybody

it's again with Citrix and Access 2010....
On different local installations everything works fine, but on Citrix I get an application crash at the line with Recordset.Update:

...
Dim vDB As DAO.Database
Dim vRS As DAO.Recordset
Set vDB = CurrentDb()
Set vRS = vDB.OpenRecordset("tblHistory", dbOpenDynaset)
vRS.AddNew
   vRS.Fields("tAdressID") = Me.tAdressID
   vHistoryID = vRS.Fields("tHistoryID")
vRS.Update
...

I've tried many things: compress, decompile, copy objects to a new DB, nothing helps.

It hat worked fine until yesterday, even on Citrix. The code haven't change so far but now Access crashes...
Crazy...

Does anybody have an idea what could be wrong?

I could add the new record with an "INSERT INTO" but then I'm not sure about the value of tHistoryID of the new record.

Thanks a lot!

Best regards
Daniel

 

[tehNellie]

vRS.AddNew
   vRS.Fields("tAdressID") = Me.tAdressID
   [b]vHistoryID = vRS.Fields("tHistoryID")[/b]
vRS.Update

Looks like that's got switched round.