empty recordset

[ben1988]

i noted when the recordset is empty (without records)
it gives me error to use recordset.addnew and recordset.update
why??
my db is dynamic, and it saves records just for 1 month (other records - it erases them automatically) so its not rare situation i need add new record to empty recordset
what to do?

thanks so much!! :)

[Oralloy]

I'm curious why you are using a recordset in preference to simply "insert"ing the record.

[zmbd]

ben1988
We need two things
+ The EXACT error message, including the Title, the number, and the text - as it is shown. Please do not abbreviate the message text.
+ We need to see your VBA script.
Please follow the guidelines for posting code found:
How to Ask Good Questions

You should also follow the instructions in post#2 of that thread and do a basic debugging. :)


Oralloy: Many reasons I will use the Add method, mainly to avoid bloat when doing multiple records or importing data from other files that need to be parsed. :)

[ADezii]

Simply because a Recordset is empty should not prevent you from adding Records to it. There should be more to this story.