Data Propagation

[Michael Stengel via AccessMonster.com]

On a form I can have a command button set up to create a new record. Anyone
know how to set up a button to creat a new record, but proppgate certain
fields with information from previous record?

 

[Guest]

If you want to retain only a few fields:
On the AfterUpdate event of that control try
const cQuote=""""
me!ControlName.DefaultValue = cQuote & Me!ControlName.Value & cQuote

If you are looking to copy a record over to a new record, try
(e-mail address removed) and search for the "Carry data over to a new Record"
article.

Hope that helps