I have a split form for entering test results. There can be a hundred results to enter - so many lines on the bottom datasheet portion and a larger top portion with a couple option controls, memo box and several fields. (So wouldn't work well in continuous form)
My user is having trouble keeping track of what line she is on when entering results and would like to be able to have a check box or something to "lock" each record when she is done entering the results. She would also like to have that line display in a different colour but from what I've been reading that isn't possible in datasheet view like in the split form. So, I'm hoping I can at least put in the locking function for one record at a time and still have the datasheet portion usable for the records that have not been locked yet. Any ideas?