How to use addRecord method?

[mikiempire]

I am puzzling by this simple question: in my simplified page, there are only one Recordset DTC, one button, named Add Record. And the whole intention of this page is to click on the button to add one record into the Recordset. The adding action is placed in the buttonAdd_onclick sub as the following list:

sub buttonAdd_onclick ()
rs.addRecord
rs.fields.setValue "ID", "100"
(setting other fields...)
rs.updateRecord
end sub

But it doesn't work...no record has been added! I have tried different database (Access database), but still the same.

I wander is there somebody outthere ever encountered same problem ? Many thanks for you help!!

 

[mikiempire]

I have figured that out myself. It turns out the problem is a bug of addRecord() method! Check Knowledge Base article Q190591 for the current status.