Try:
Docmd.RunCommand acCmdSaveRecord
Try:
Docmd.RunCommand acCmdSaveRecord
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
No luck. It doesn't work unless I switch from Form View to Design View, then back to Form View...
June7, problem solved. I had to requery at the end. Thank you for all the help!