force after insert with VBA

[mcourter]

i need to force a new record to be written.
DoCmd.Save is not forcing the insert.
how can i do this?
tia.

 

[Lynn Trapp]

DoCmd.Save does not save records. Rather it saves the currently active
object -- form or report. Me.Refresh or Me.Requery is more likely what you
need.

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Big List: www.ltcomputerdesigns.com/JCReferences.html

 

[mcourter]

yes, requery works.
now i need to get back to the newly saved record.
working with DoCmd.GoToRecord.
thanks,
mc

 

[Van T. Dinh]

Another way is to use:

DoCmd.RunCommand acCmdSaveRecord

The current Record stays the same and you don't need to navigate back.