In short, no. Access will always want to display the new record at the
bottom of the form.
You could get sneaky and use another subform and display it "above"
your regular form. With some judicious manipulation via code you should
be able to see what you want.
Your right Wayne its not worth it. I have read through some similar posts and using information from there I will just sete the forms Data Entry property to True. Thanks anyway