Datasheet help Needed

C

Charles

I have a datasheet that accepts news rows. when the row is entered a popup
menu appears and a processing option is selected. The problem is that if
the user does not click on a row other than the one just entered the
database is not updated and the record does not exist to be processed.

If I have the user click on ANY other row the update to the database is
forced and everything works fine.

Question: How can I programatically forced the newly entered row to be
updated to the database without clicking to another row.

I have tried Movefirst, movelast and refresh without success.

Any help is appreciated

CL
 
J

John Vinson

Question: How can I programatically forced the newly entered row to be
updated to the database without clicking to another row.
Click to expand...

Two ways (in VBA):

DoCmd.RunCommand acCmdSaveRecord

or

Me.Dirty = False

John W. Vinson[MVP]
 
Top