Default values

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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.
 
Back
Top