Duplicating several fields with 1 click

[Julie123]

Hi

I need to be able to copy 5/6 fields from one record to the next then carrying on entering different data, ie copy date, location, time then enter name address etc.

I can copy the whole record but not just a couple of fields

Any ideas?

I am using access 2000.

Thanks

 

[Malcy]

Hi
Best way might be to copy the fields you want to variables then use the same variables to populate the next record.
Sort of strClientName = Me.txtClientName to copy then when you move to the next record you reverse using Me.txtClientName = strClientName
I think this would do the trick. May be more elegant ways though!
Good luck

 

[Banana]

Why not use wizard to create command button that will do a "Duplicate Record" and see what code it uses. I can't remember if the code for this particular situation is obsolete, though.

 

[B4Geyer]

See if the KB article KB88670 helps at all:

http://support.microsoft.com/default.aspx?scid=kb;en-us;88670

 

[Banana]

I'm not sure how the article KB88670 is better than setting several fields' default value....

 

[ansentry]

Is it always the previous record that you want to copy from?

You should be able to make the code in the sample suit your form.

If you want to "Duplicate" a selected record then post back.

 

[WrHn85]

Ability to copy but not default

If you didn't want that as the default, but rather wanted the ability to copy selected fields from previous record when necessary, would you put the code from the above example in a "Copy" button instead?

 

[ansentry]

WrHn85,

Short answer is No.


If you want to copy a selected record then have a look at the attached sample;

 

[WrHn85]

Wow - that does it nicely. Thanks again, John!

 

[vangogh228]

The solution I found was to take the fields you need over and over again and put AfterUpdate code that makes sets the DefaultValue to the entered value, then turns the tab stop off. All fields are required, so they can't miss any. Then, when they enter the one field that will change, and tab forward, all the values in the other fields stay until they close the form. I put OnOpen code on the form that takes it to a new record. That seemed to work to make it so the fields were blank the next time I opened the form (they didn't hold the default from the previous record when the form was opened the last time).

 

[Steve R.]

Ansentry: At work, I was asked to develop the feature of copying data from any record into a new record. Your solution and test database will really speed this development. Thanks.

 

[ghudson]

Check out the duplicatecurrentrecord.zip sample I posted @ make a duplicate of a record

 

[Steve R.]

Ghudson: I just finished the project and I came to check the forum again. I was amused by your discussion on "NULL" values since it was so true. I had to do quite a bit of data validation as a precursor to adding the data to the new record and one of the stumbling blocks was the "NULL" value. Basically, I tested for the "NULL" and zero length string situations and if true entered "Data Not Available" into the textbox. All is well, thanks for the help.

 

[ghudson]

Glad I was able to amuse you today.