G
Guest
Hello,
I built a purchase order form from a query in order to autofill information
such as Employee for who completed the purchase order, Ship to and Vendor
information from combo boxes. It works, but until you select select from the
combo boxes first on the form I keep getting the same error message:
Microsoft Jet Database engine cannot find a record in the table "Vendors"
with key matching field(s) 'VendorID'
I get the same error for the ShipTo and Employees as well when there is a
ShipToID, EmployeeID and VendorID in the table.
These are the control sources, but I have them display/autofill the Name and
address info for all three. Everything works, pulls the correct info, but
this error message is an annoyance and don't know what to do to fix the
problem.
Thank you
I built a purchase order form from a query in order to autofill information
such as Employee for who completed the purchase order, Ship to and Vendor
information from combo boxes. It works, but until you select select from the
combo boxes first on the form I keep getting the same error message:
Microsoft Jet Database engine cannot find a record in the table "Vendors"
with key matching field(s) 'VendorID'
I get the same error for the ShipTo and Employees as well when there is a
ShipToID, EmployeeID and VendorID in the table.
These are the control sources, but I have them display/autofill the Name and
address info for all three. Everything works, pulls the correct info, but
this error message is an annoyance and don't know what to do to fix the
problem.
Thank you