Good afternoon,
I am having difficulties with a subform in datasheet format. The subform is linked to the master form with SOWID. Works great. My subforrm fields are required to prevent errors. I am using the validation and Validation text areas for each field. When I attempt to see if it is working correctly, I receive the message below which is an Access generated message. It is only showing on "Product" field. Tall other validation codes are working perfectly. I have a one to many relationship Product to Price linking the tables. The query is strictly coming from the tblPrice.
"Microsoft Access database engine cannot find a record in the table 'tblProduct' with the key matching fields 'ProductID'"
I have the validation rules in place so the end user will understand what they are missing. Anyone know how to bypass the MS Access generated msgbox so that it will utilize the message I have in place?