I am hoping to save my data entry staff a lot of time entering long ID numbers for genetic samples in our database. I have been able to carry forward values in forms in datasheet view, but I'm having trouble figuring out how to carry forward a sequential alpha numeric code with an incremental value.
For example, if a label is entered, say 19DYS001, I would like it to autofill on the next record with 19DYS002, 19DYS003, etc. until the field is edited to a null value, at which point there would be no further entries until another code is entered.
Excel seems to be able to carry forward a sequential alpha numeric code with a drag down feature. Is there a way to accomplish something like this in access? Thanks.
For example, if a label is entered, say 19DYS001, I would like it to autofill on the next record with 19DYS002, 19DYS003, etc. until the field is edited to a null value, at which point there would be no further entries until another code is entered.
Excel seems to be able to carry forward a sequential alpha numeric code with a drag down feature. Is there a way to accomplish something like this in access? Thanks.