Saving data to a table

  • Thread starter Thread starter Laurel
  • Start date Start date
L

Laurel

How can I be sure that data in a new row is saved to a table before I issue
a .Requery? That is, if the data is entered, but the user doesn't move to
the empty new row before launching a procedure that does a Requery? The
SAVE method seems to apply to things like forms and table definitions.
Update applies to a SQL statement. Is there a way to force a new row to be
written out?

tia
las
 
Laurel said:
How can I be sure that data in a new row is saved to a table before I issue
a .Requery? That is, if the data is entered, but the user doesn't move to
the empty new row before launching a procedure that does a Requery? The
SAVE method seems to apply to things like forms and table definitions.
Update applies to a SQL statement. Is there a way to force a new row to be
written out?
Click to expand...

DoCmd.RunCommand acCmdSaveRecord
or
Me.Dirty = False
 
Back
Top