I have a database for members of a dog training club. I am very inexperienced in Access and have taught myself via the internet.
I have created the tabbed form below to keep each members details. The members pay an annual fee and the date of payment is entered into the membership paid field. I also have a table called payment and have placed a subform on the renewal tab to record dates the following years payment is made.
What I would like to be able to do is when the member makes a renewal payment is to edit the date in the membership paid field on the general tab so that this will show the most recent payment date and have the old date automatically populate the payment table and show on the subform on the renewal tab.
Is this possible? I was thinking of a before update event on the membership paid field but i've tried numerous ways and cannot get this to work.
Any help and advice would be appreciated.
I have created the tabbed form below to keep each members details. The members pay an annual fee and the date of payment is entered into the membership paid field. I also have a table called payment and have placed a subform on the renewal tab to record dates the following years payment is made.
What I would like to be able to do is when the member makes a renewal payment is to edit the date in the membership paid field on the general tab so that this will show the most recent payment date and have the old date automatically populate the payment table and show on the subform on the renewal tab.
Is this possible? I was thinking of a before update event on the membership paid field but i've tried numerous ways and cannot get this to work.
Any help and advice would be appreciated.