I am copying a current record to a new record via VBA code...
Dim RS As DAO.Recordset
Set RS = CurrentDb.OpenRecordset("tblMeterCertification")
RS!RecordDate = Date
RS!blah, blah, blah
Set RS = Nothing
But after the record has been copied I want the form to close and re-open displaying the new record.
How can I do this?