Form and its Subform Problem

[FilterMe]

Hi there

I have two forms; one called frmMembership and frmPayment.

frmMembership from Members table
frmPayment from Payment table

Members table is related to Payment table as one-to-many

frmPayment is subform in frmMembership

What I need to do?

When you open frmMembership, I want to add the payment details from specifc fields of frmMembership to specifc fields in frmPayment. The fields I want to copy across to frmPayments are txtAmount and Today's Date. This must be opied when the Add button is pressed. HOW CAN I DO THIS?

The the subform; frmPayment must include the payment history of all members.

Waiting for help
Thank you

 

[FilterMe]

Corrected

when add is pressed the data I mentioned above must be copied. Misspelled above!

 

[mark curtis]

zip up the db and post it here and it will be looked at

 

[FilterMe]

Attachment of the problem included

The Database of the problem included. Please review it.

 

[FilterMe]

Help

Please have a look at the frmMembership

I need to keep a record of each payment a member makes by a press of the Add button. These records should go into the sub form frmPayment.

ANY HELP AT ALL