Create a new Parts record from an exiting one

[Peter Marshall]

I would like to create a form that prompts for an EXISTING part number
record in my tblParts and then creates a NEW part record for a prompted NEW
part number. All of the existing field values would be "copied" to the new
part record. I have looked around for a solution to this but have had no
luck. Can anyone point me to some examples of this?
--

Peter Marshall
Manager Information Services
Ohio Coatings Company
(740) 859-5560 office
(304) 281-7404 cell

 

[Allen Browne]

Peter, how about adding an unbound combo to the top of your form, where the
user selects the part they want to copy. Then a Duplicate button that copies
that to a new part.

There is a combo box wizard to do the first one for you, and a command
button wizard to do the 2nd one. Alterantively, there's code for the combo
box here:
http://allenbrowne.com/ser-03.html
and there's code for the Duplicate button here:
http://allenbrowne.com/ser-57.html
(The 2nd link explains how to duplicate the records in a subform as well,
but you can just ignore that part.)

 

[Peter Marshall]

Allen,

This is exactly what I was looking for -- straightforward and easy enough
for me to understand. Thanks. BTW, your former web site at bigpond.net has
always been in my bookmarks but wasn't found. I now know where to find you!

Peter Marshall
Manager Information Services
Ohio Coatings Company
(740) 859-5560 office
(304) 281-7404 cell