Run-time 3101

G

GarrettD78

I just inherited a database that someone created a long time ago. Apparently
the user of the Database incorrectly entered some information an tried to
delete the record out of the database. After doing that she tried to go back
in and enter some new records, but now every time she tries to enter the info
she gets a run-time 3103 error "cannot find record in table 'SubItems' with
matching fields 'Item'." I have been working on this and think this error is
part of a combo box that gets refreshed and narrowed down as the user enters
information into the rest of the form. The combo box is attached to a query
SELECT SubItems.ItemID, SubItems.ItemCategoryID, SubItems.Item,
Vendors.Vendor FROM Vendors INNER JOIN SubItems ON
Vendors.VendorID=SubItems.VendorID WHERE
SubItems.ItemCategoryID=[ItemCategory];


And the tables that are queried are:

SubItems:
ItemID AutoNumber
ItemCategoryID Number
Item Text
VendorID Number
CategoryID Number
UnitsID Number
Cost Currency

The item table is there I just can't figure out what is going on. Any help
would be appreciated.
 
Top