I have a form used for data entry.
Its purpose is to allow me to check the ammount of work a particular employee finishes in a day.
Only three peices of data are entered:
Employee
Lines Pick (numberic)
Date [defaulted to now()]
The "lines picked" value is a list of numbers the employee has recorded throught the day showing the size of the orders they have processed. The person handling the data entry for me needs to select the employee from a Combo box that I made (using a lookup to another table), and type in the lines picked values. Each employee might have 20 or 30 values to enter under their name at the end of the day.
What i would like to do is set the combo box with the employee name so that it defaults to the value used in the last record. That way, the data entry user does not have to select the employee on every record--but can simply type the numeric values rapidly with employee and date defaulting. Then, when the user changes employees, they can switch the combo box to another employee in the list and continue, with each new record defaulting to this new employee selection.
Is there an easy way to do this? Is there a way to lock cetain fields in the form so that they remain the same in any new record until the user changes them? Sort of like a "selectable default" in the form itself.