Apart from using the visible controls on the DataControl, you can also use code to move around the database:
Data1.Recordset.MoveFirst '// moves to the first record
Data1.Recordset.MoveLast '// moves to the last record
Data1.Recordset.MoveNext '// moves to the next record
Data1.Recordset.MovePrevious '// moves to the previous record
If you use .MoveNext when you are at the last record, and EOFAction is set to
vbEOFActionAddNew, a new record is added (see below)
Comments