Question monthly/annual renewal popup message

[munkeyroot]

Hi I hope some one can help
I am creating payment database for a community gym, i'm not very good with vb.
the data will be created on a data sheet.
there are 2 payment types monthly and annual (these are on a dropdown box with their own id number).
I have a joining date and a paid date, but reflected against the payment type ie 31 days or 365 days.
i have been trying to do something along the lines of:
if [monthly] (is selected) (so this would call up a 31days) date() is > [joining date] then give message to renew and same kinda thing for annual.

i'm propably on the totaly wrong track but i hope someone can help

Cheers
Munk

 

[Pat Hartman]

Having a popup of this nature is only useful if you "touch" the record. Are you trying to tell people as they check in that it is time to review? If not, a batch process is better. Do you want to send invoices to people? How do you want to communicate the need to pay? Your business rules need clarification.