Thanks Curtis. I was able to get that part to work without the Object error message, however, now when my Add Items form opens up, it doesn't fill in the SupplierName field. I've tried the following code on the After Update event for the SupplierPartNo field on my Add Items form (this is an...