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


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.
 
Ad

Advertisements

J

John Vinson

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.

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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top