Form for payments - Access 2003

[Nomy]

Hi,

I'm building a database to record payments for martial arts classes. Most
students pay on a monthly basis. Students have different begin dates and
monthly payments are due one month after registration. Ex: registration is
5/3/09 so payments are due on the third day of each month. How can I have
the DateDue post automatically in my subform so I don't have to enter this
every month. The purpose is to have Access post an automatic late fee if
paid X # of days late.

I have a parent form for the student classes with tuition amount, a begin
date and end date, and a monthly payment
amount. In the subform, I have the fields DateDue, AmountDue, DatePd and
AmountPd.

Thanks.
Joy

 

[Al Campagna]

Nomy,
Well, most probably you don't want it to enter "automatically"... you'll
be
better off using some logical event to "fire" the 1 month DueDate add...
You could double-click the blank DueDate on a new subform record. The
double click would fire code to determine the maximum DueDate currently
exisiting (for that member), and placing a value one month greater in the
new
record's DueDate.
Aircode...
Private Sub DueDate_DblClick(Cancel As Integer)
LastDueDate = DMax DueDate in the subform for that MemberID
Me.DueDate = DateAdd("m",+1, LastDueDate)
End Sub
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."

 

[Nomy]

Al,
Thanks so much for your help. I'm sorry for not thanking you sooner, but I
was unable to check the news group for several days due to illness. Your
advice makes sense and I'm trying it now.

Thank you again.
Nomy

 

[Al Campagna]

OK, let us know how you make out.
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."