I'm using the menu's Data Form function called by a macro to enter new
records to a spreadsheet database used to track employee time to be billed on
client matters. For simplicity, assume the fields corresponding to the
columns in the database a employee, file number, time, code and code
description. It is common that groups of related records are entered in
sequence where, for example, each new record in a group is has the same file
number and employee. Employee and code fields validate from respective lists.
Code decription field populates from a VLOOKUP function based on code field
entered. I'm calling the Data Form from the menu via a macro. Each new
entry, however, begins with a clear cell for each field. I'd like to have
the fields, at least employee and file number fields, for each new record to
be added initialize with the values entered for the immediately previous
record so that the information does not need to be re-entered for each new
record. Is there any way to do this using the Data Form? Will I need to
create a different data entry form in VB? Very much a newbie attempting this
but generally a quick study.

Thanks!


--
Message posted via http://www.officekb.com