Error when data added to table in subform

C

CAT

i am trying to create a form (for vehicle maintenance
management) that joins 2 excel spreadsheets linked to the
database, 1 Access.db table, and 1 subform table (an
access db subform table). The form works fine bringing in
existing data from one of the Excel spreadsheets, and all
parts of the form and subform view.

However, when I add data to the subform table, I get an
error message that says "Object is invalid or no longer
set". The data I have entered in the subform does not
show up in the form, although it is entered in the table.

Please let me know if you need any additional
information. Thanks for your help on this.

CAT
 
Top