Easiest way to copy all but one field into a new record?

[Montez659]

The title pretty much says it all. I have some records that will be archived, but most of the information on there would be valid and would save time if I could copy that record into a new record, with the exception of one or two fields.

Or I could even copy the whole record and just update the two fields, but I am trying to do this via a macro as opposed to VBA (not that I have anything against VBA, I can use it if need be).

What is the easiest way to do this? I created a command button and actually let the wizard set up a copy record function. But like I said, I need to reset a few fields.

Thanks!

 

[Phildaburn]

Take a look at the VBA code that the wizard created on your command button. Insert the code to change the stuff you want changed and you're good to go.

 

[Montez659]

Phil, thanks for responding. The wizard created it in a Macro and not in VBA. I decided to do it in VBA, because really, there is not much difference in how it operates.

Thanks for the help!

 

[Norie]

You really should try using VBA over macros, it'll give you much more flexibility.

Mind you nothing wrong with using wizards or macros to generate the initial code - you can always change it later to suit your needs.

Oh, and of course you can convert macros to VBA.