Copying In A Continuous Form

[Guest]

Is it possible in a Continuous Form to copy information from one field to the
next without having to use the copy, paste command. I have a Form with
Fields January thru December. If the number I enter in January is 100, and
the same number should be in the months February thru December, I want to use
a feature that copies and pastes the 100 in those months, however, using
copy, paste isn't saving time. Is there a way to do this?

Thank you!!

 

[Guest]

Jen,

A table with fields

Jan
Feb
Mar
....
Dec

likely would have a better normalized structure of:

Month
Amount

but, leaving that aside, you can assign the other fields directly in an
event procedure:

Me!February = Me!January
Me!March = Me!January
....etc.

either in the January AfterUpdate event, or attached to a command button.

Sprinks

 

[John Vinson]

Is it possible in a Continuous Form to copy information from one field to the
next without having to use the copy, paste command. I have a Form with
Fields January thru December.

Then you have an improperly normalized table structure behind the
form. Storing data - months - in fieldnames is simply WRONG, and will
get you into trouble! Just for starters, is the value in January for
January 2005, or January 2006? How can you tell?

As Sprinks suggests, you REALLY want to normalize your table design
first! Then you'll be able (if it's necessary and appropriate) to run
an Append query to populate the twelve records for 2006.

John W. Vinson[MVP]