I have a form that enters the records. When I enter a record and save it. I need to go back to the record so I can edit a subform that is linked to the record. I have a macro that instructs to go to last record but it does not go there. I have tried to format Action Date as General (06/13/12 10:24:30) but the record shows (06/13/12). Also, the records are not in the order I entered them when I sort by action date.