ADO vs DAO with recordset operations
I'd go with John's suggestion, and use DAO, but just for the sake of
completeness, the reason you're having trouble using AddNew is probably
because, unless you specify the appropriate arguments, the ADO Open method
defaults to opening a read-only recordset.
--
Brendan Reynolds (MVP)
Access 2000/2002 sample app at
http://brenreyn.brinkster.net
----------------------------
Quote:
> Greetings all,
> I am trying to populate some fields in a subform based on
> the data entered in the master form. this is accounting
> stuff, so enter general info to receive an invoice, and
> have the code write the details into several records in
> the subform. I have done this with earlier versions using
> the open recordset operations using DAO. Hwever, my new
> 2002 version seems to be leading me to 'ADO' what ever
> that is. I can open the recordset (querydef in the old
> lingo), but I cannot use the AddNew procedure, etc within
> the rcdset.
> Can anyone guide me to a more general discussion on what
> has changed in the access 2002 programming language, and
> specifically how to get around (or a better way to do
> this). I am a casual programmer with not enough time to
> really dig into the languages.... rather using wizards
> until I have to code something. It's quicker!
> Cheers,
> BRich
