See:
Assign default values from the last record
at:
http://allenbrowne.com/ser-24.html
The article explains how to have a form automatically add the same data you
had in the last record, as soon as you start entering a new one.
--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users -
http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"Karen" <(E-Mail Removed)> wrote in message
news:196B757D-A334-4B62-81E7-(E-Mail Removed)...
> Is it possible to copy a record in a subform? I want to have all field
> values
> except one (or maybe 2) be the same.
>
> Thanks.
>
> Karen