I'm working with 2 tables that have corresponding forms. The talbes are "Donors" & "Donations". The tables are linked by "DonorID"
On the Donors form I've added a command button that opens the donations form and once the form is loaded it is supposed to automatically enter the DonorID on the donations form.
When I enter the donations form the DonorID & the Donor's name appear however when I enter the donation information and try to close the form I get the following error:
The Microsoft Jet database engine can't find a record in the table "Donors" with key matching field(s) "DonorID". (Error 3101)