This worked great on the BeforeUpdate of the main form and is adding the correct value into a new record in the payment table. However the new record has no member ID. (Fields in table are MemberID and date_paid) It's also not showing on the subform as obviously its not attached to that Member...
I am manually entering the dates into the renewal tab, but would like to automate it so if I edit the membership paid date on the general tab it will automatically enter the old value (before editing) into a new record on the renewal tab
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...
Hi everyone.
I'm a member of a dog training club and to help out have created a database for member information.
I have no experience in Access and everything I have created has been by learning from the internet.
Hoping to get a little help to improve.