Recordset update

[joey o.]

Hi,
I want to structure my programming more but when i put a call to an update of my recordset outside the sub that does the Rs.AddNew I get an "Update without AddNew" error. The Rs is public and the Rs.AddNew is in a loop to grab Rs!Item = varItem.Any suggestions?
Thanks

[MartinLiss]

Post some of your code.

[Wen Lie]

First of all, just post some of your code.
At least that 2 related modules. So, we can figure out what is the mistake.
Because, I've done something like that, and, it works. I've put rs.Addnew at a module, let's say at Add Module. And I put rs.Update at another module, let's say at Save Module. Everything is okay.

Please check the routine. Who knows that you've done something wrong in calling module.

Regards,
Wen Lie
( VB Database Programmer )