M mcourter Jun 8, 2005 #1 i need to force a new record to be written. DoCmd.Save is not forcing the insert. how can i do this? tia.
i need to force a new record to be written. DoCmd.Save is not forcing the insert. how can i do this? tia.
L Lynn Trapp Jun 8, 2005 #2 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
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
M mcourter Jun 8, 2005 #3 yes, requery works. now i need to get back to the newly saved record. working with DoCmd.GoToRecord. thanks, mc
yes, requery works. now i need to get back to the newly saved record. working with DoCmd.GoToRecord. thanks, mc
V Van T. Dinh Jun 8, 2005 #4 Another way is to use: DoCmd.RunCommand acCmdSaveRecord The current Record stays the same and you don't need to navigate back.
Another way is to use: DoCmd.RunCommand acCmdSaveRecord The current Record stays the same and you don't need to navigate back.
