hi, i am using access 2007 with XP.
when open a form, to list the existing records in the table, i set No to data entry property in the Data tab. however, in this way, it will always show the 1st record in the table when user open the form.

i wonder if i can have all existing records listed below the form fields and have the focus on a new row when a form is opened.

any help is appreciated


thanks,