How do you view an Access table in a form

I would like to view the records in my table from a form. So when I add a new
record in a form and save, this new record is displayed in the table at the
bottom of my form (kind of like a view of the top five rows of the table).

On Tue, 16 Nov 2004 09:17:02 -0800, BoltonLad
wrote:

I would like to view the records in my table from a form. So when I add a new
record in a form and save, this new record is displayed in the table at the
bottom of my form (kind of like a view of the top five rows of the table).

Yes... and your question is?

You're viewing the records in your table on the form. You can use the
scroll bar to find any record you wish. You can base the Form on a
Query sorting the data in any way you wish; if you have an Autonumber
(or better, a date/time field defaulting to Now()) and sort the data
descending by that field, you'll see the most recently added record
first. Or, you can add a little VBA code to your form to jump to the
last record on opening the form:

Private Sub Form_Open(Cancel as Integer)
DoCmd.GoToRecord , , acLast
End Sub

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps