Dave, thanks for the reply and comments.
 The 3rd issue is not running on a macro, it when I run the append query then the table opens automatically 
4th issue, I mean I would like to see All the entries including the last I entered, but not using the “F5” functional key on key board.  I could...