I have a form that collects test information about a large number of parts. The parts need to have the batch numbers of materials inputted along with the test data. These batch numbers vary from part type to part type.

I have previousely used code to Auto Fill the batch numbers from the previous record.

What i now need to do for example is say i have a record for Part A, then a record for Part B, My third record is for another Part A and i want to AutoFill from the previous Part A, How can i do this?