Hi All,
Not sure if I am on the right track with this one or not, but I created a datasheet subform to add in records from two tables. When I add a new record directly into the datasheet (without it being in the main form), the tables update great without errors. However, when I try to add new records into the subform from within the main form, for some reason as soon as I have entered a date into the first column and tabbed to the next column there is an error 3101 displayed that says the Microsoft Jet Database can't find a record in the table. This is weird because I had not even entered the record in at this point, it is as though the datasheet is trying to update the table before I have completed entering the data in. Incidentally, when I have okayed the error messages and completed entering info into the record, the relevant table has been updated fine.
This is probably something simple that I have missed, but if anyone can let me know if they have had the same problem and any ideas on how to solve would be great.
Thanks
Zippy
Not sure if I am on the right track with this one or not, but I created a datasheet subform to add in records from two tables. When I add a new record directly into the datasheet (without it being in the main form), the tables update great without errors. However, when I try to add new records into the subform from within the main form, for some reason as soon as I have entered a date into the first column and tabbed to the next column there is an error 3101 displayed that says the Microsoft Jet Database can't find a record in the table. This is weird because I had not even entered the record in at this point, it is as though the datasheet is trying to update the table before I have completed entering the data in. Incidentally, when I have okayed the error messages and completed entering info into the record, the relevant table has been updated fine.
This is probably something simple that I have missed, but if anyone can let me know if they have had the same problem and any ideas on how to solve would be great.
Thanks
Zippy
