Info entered into form not being reflected in table. HELP!!!

  • Thread starter Thread starter Rhythm
  • Start date Start date
R

Rhythm

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_Gifts_Click:
Exit Sub

Err_Gifts_Click:
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?

Thanks.
 
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.
Click to expand...

Um? That's the hard way to do something simple! Why not put the
Donations form onto the Donors form as a Subform, with the DonorID as
the linking field? No code, you can see the donor information and
their donations at the same time!
 
Back
Top