Albert, you there?

[Sandra]

Well fiddlesticks, one step forward, one step back LOL! I
still have a glitch, so I'll explain what I have now.
On the tabbed form I have just the datasheet subform,
this subform is from a query which filters for the
donation records based upon the PK in master PeoplePlaces
table. This works well because I can see more records.
This form cannot be edited. The OnClick event opens the
DonationsForm form filtered by the donation transaction
PK DID of the clicked record. This form allows for all
the edits, etc. and works just fine. However...I still
have a bit of a problem with new data.

I created a new form DonationsNew, identical to
DonationsForm, but set to DataEntry. I have a NEW button
which opens this form. I can link the first new record
to the PPID record in PeoplePlaces, but after that the
PPID is not being passed to the form. Here's what I have
in the OnClick of the NEW button:

Private Sub NewRecord_Click()
On Error GoTo Err_NewRecord_Click
MyID = Me.PPID
Dim stDocName As String
stDocName = "DonationsNew"
DoCmd.OpenForm stDocName, acNormal, , , acFormAdd
Forms!DonationsNew.PPID = MyID
Exit_NewRecord_Click:
Exit Sub

Err_NewRecord_Click:
MsgBox Err.Description
Resume Exit_NewRecord_Click

End Sub

So, I guess what I need now is how to continue to pass
the PPID variable to each new record.

And one last thing will make this really functional...how
do I requery the DonationsList datasheet form after a new
record is added?

Thank you so very much. You have been a Godsend!
Sandra