Autofill subform entries

[Guest]

I need help on autofilling subform entries.

I have a main form (student record) and sub form (class record of that
student) the Class subForm changes each month and is used to calculate the
montly statements.
Access 2007
The Class subForm has various information in it that has to be entered each
month with changing data. However, the following information only changes one
in awhile class, days and tuition. I need to be able to automate (autofill)
that information each month based on say the last months entry. But I only
want to update those specific fields and the ability to go back an manually
change them if necessary.

Any suggestion would be so much appreciated.

Thank You

 

[Guest]

Hi Francine,

You might give this method a try (I haven't ever tried it on a subform).
Sorry, I don't know of an Access 2007 version of this article:

How to fill a record with data from a previous record automatically
in Access 2000 and 2002 and Office Access 2003
http://support.microsoft.com/?id=210236

Access MVP Allen Browne has this article as well:

Assign default values from the last record
http://allenbrowne.com/ser-24.html


Tom Wickerath
Microsoft Access MVP
https://mvp.support.microsoft.com/profile/Tom
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________