Default values

C

CRAIG KELLY

I have lots of forms which contain quite a lot of data, the majority of the datain each record will be the same, how can I set the fields so that when I create a new record it is populated with the value from the previous record, I know I can set a default value in the table but considering how many fields I have it will take ages, can I do this globally?

A lot of my forms are linked to one main form by using subforms so when I create a new record it creates one for each form linked via the subform is there a way of copying the main form record so that it would copy all the subforms too? Lotus approach had this facility but i haven't found it on access as yet

Any help is appreciated.
 
C

Cheryl Fischer

AFAIK, there is no global setting to do this, but there is code at the
following link which may be of help:

Forms: Carry current value of a control to new records
http://www.mvps.org/access/forms/frm0012.htm



--

Cheryl Fischer, MVP Microsoft Access



CRAIG KELLY said:
I have lots of forms which contain quite a lot of data, the majority of
Click to expand...
the datain each record will be the same, how can I set the fields so that
when I create a new record it is populated with the value from the previous
record, I know I can set a default value in the table but considering how
many fields I have it will take ages, can I do this globally?
A lot of my forms are linked to one main form by using subforms so when I
Click to expand...
create a new record it creates one for each form linked via the subform is
there a way of copying the main form record so that it would copy all the
subforms too? Lotus approach had this facility but i haven't found it on
access as yet.
 
Top