I have 2 tables. "Donors" & "Donations" the tables are linked by "DonorID". I have created forms to correspond with the tables and on the "Donor" form I have a command button {this may be some of the issue, I'm not quite sure} that has the following event procedure:

Private Sub Gifts_Click()
On Error GoTo Err_Gifts_Click

DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70
DoCmd.OpenForm "Donations"

Exit Sub

MsgBox Err.Description
Resume Exit_Gifts_Click

I also have a query "Giving History Query" which is displayed on the Donors form.

The idea is to add a gift and once it is added and I have returned back to a particular donor's record I can view all of the donations he/she has made.

The first time I used this it worked fine, I've added additional gifts and noticed none of them were reflected in ithe Gift History Subform for the donor. This prompted me to take a look at the Donations table at which point I discoverd that the table DID reflect the donations however, it did not record the DonorID for the donation. But when I'm in the "Donations" form the donor's name does appear in the field for the donor.

Oh, FYI I have both the DonorID & Donor Name field on the donations form but the DonorID field is not visible.

Can anyone tell me what I've done wrong?