Hi. wonder if possible. Have a db. have a form with a subform (datasheet view of a query). This subform may contain 10 items or it may contain more ie up to 100. The user needs to enter a range of numbers in a textbox ie 1-100 and have the numbers be assigned/distributed across the 100 records in the subform. Doesn't matter what order they land in as long as each only get one number and none have the same. is this possible?