selectively carry values forward to next record

[BRC]

I am sure this has probably been asked and answered several times but
I cannot find code to this specific issue.
I have a contact data base. I would like to put a command button on
the new record form that would add a new record and carry current
values for some fields forward to next record. For example, i add new
record that includes fname, lname, address, phone etc.. In some cases
i want to add another record and carry forward the address and phone.
Can some one direct me to an example of this sort of thing. I have
seen the autofillnewrecord routine in Kb article but I am not sure how
to set that up so that it only occurs when i want to as opposed to
every new record. I have also tried to use some to code outlined in
Allen Brown's posts but i can't find something real close to what i am
trying to do. thanks in advance for any suggestions.
BRC

 

[Smartin]

I am sure this has probably been asked and answered several times but
I cannot find code to this specific issue.
I have a contact data base. I would like to put a command button on
the new record form that would add a new record and carry current
values for some fields forward to next record. For example, i add new
record that includes fname, lname, address, phone etc.. In some cases
i want to add another record and carry forward the address and phone.
Can some one direct me to an example of this sort of thing. I have
seen the autofillnewrecord routine in Kb article but I am not sure how
to set that up so that it only occurs when i want to as opposed to
every new record. I have also tried to use some to code outlined in
Allen Brown's posts but i can't find something real close to what i am
trying to do. thanks in advance for any suggestions.
BRC

Hello,

You could create an INSERT query or two based on the form's current data
and create a button (or two) to fire the query [and perhaps move to the
new record].