ACC: Fill Record w/Data from Prev. Record Automatically (95/97) (136127)
The information in this article applies to:
- Microsoft Access for Windows 95 7.0
- Microsoft Access 97
This article was previously published under Q136127 SUMMARY
Moderate: Requires basic macro, coding, and interoperability skills.
When you are creating new records by using a form, you may want to speed
the data entry process by having fields in the new record fill
automatically with values from the previous record. This article shows you
how to create a sample Visual Basic for Applications function called
AutoFillNewRecord() that enables you to fill selected fields (or all
fields) in a new record with values from the previous record automatically.
NOTE: This article explains a technique demonstrated in the sample
files, FrmSampl.exe (for Microsoft Access for Windows 95 version 7.0)
and FrmSmp97.exe (for Microsoft Access 97). For information about how
to obtain these sample files, please see the following articles in the
Microsoft Knowledge Base:
150895
ACC95: Microsoft Access Sample Forms Available in Download Center
175066
ACC97: Microsoft Access 97 Sample Forms Available in Download Center
REFERENCES
For more information about the For Loop, search the Help Index for "For
Each...Next Statement," or ask the Microsoft Access 97 Office Assistant.
Modification Type: | Minor | Last Reviewed: | 10/11/2006 |
---|
Keywords: | kbhowto kbProgramming KB136127 |
---|
|