ADO newby question

[James Merte]

I am migrating my MDB forms and reports to ADP (2003) connected to SQL
Server 2000. My forms are bound to the currentproject connection and single
tables on the server.

Very basic question:
In VBA how do I force an update or insert after a record is edited or added
so that the AfterUpdate or AfterInsert events get fired? These events occur
if I use the the navigation buttons to change records but I want either a
Command Button or GotFocus procedure to handle committing the updates.

Thanks

 

[PBsoft]

I am migrating my MDB forms and reports to ADP (2003) connected to SQL

Server 2000. My forms are bound to the currentproject connection and
single tables on the server.

Very basic question:
In VBA how do I force an update or insert after a record is edited or
added
so that the AfterUpdate or AfterInsert events get fired?

These are Access events, they are available either in MDBs or in ADPs.

These events occur
if I use the the navigation buttons to change records but I want
either a
Command Button or GotFocus procedure to handle committing the updates.

You can normally insert a command button and in the Click event procedure
you may force saving pending changes with the following code:

Me.Dirty = False