Form, subform autoupdate and carry forward question

  • Thread starter Thread starter SeeAll
  • Start date Start date
S

SeeAll

Hi,

My database is for UK Census transcriptions. I use a form with all the unchanging data on and a subform with the household data. The census page is made up of twenty five lines of data with nineteen fields. I enter this line data in Single Form View. When I start entering data for each line the page number and some other fields will remain the same for the whole page i.e.. 25 lines, at present I type this data in. When I start a new page I want to carry forward the same data from some of the fields, but if the data changes on the page I want the new data to carry forward. Any ideas how I might do this?

My previous database used DB4 which did all the above automatically.

Also I have one field which counts and stores the line numbers 1 - 25 this might extend to 27 in some cases. I would like this field to increment itself for each page. How can I do this?

TIA

SeeAll
 
SeeAll,

I'm sorry, I can't quite grasp the meaning of the relationship between
the "lines of data" and the fields. But anyway, these ideas might be of
soem value to your work...
1. There is a keyboard shortcut Ctrl+' (Ctrl and apostrophe) to
automatically enter the same data into a field as the data in the same
field in the previous record.
2. You can put code on the AfterUpdate event of any control on the form
whose data you want to be carried forward to the next record...
Me.NameOfYourControl.DefaultValue = Me.NameOfYourControl
 
Back
Top