copy record does not copy all fields

[rjmdt]

I have a form that I use to copy records and then change a few fields to create a new record. A few fields do not copy one of them is a primary index key. When I try and save the record it gives me an error null primary key error. Do I have to have the field on my form for it to copy? Another possible thought is how do I update the primary key from two of the fields that do copy on the form. The primary key is made up of two fields that are copied then the user makes the changes to these fields, I would like for it to update the primary key before updating the record.

Thanks in advance

 

[KenReay]

Hi

You need to explain how you are copying the data, for example do you execute an SQL Insert Command to create a new record with data from the Form, or what ?

Regards
Ken Reay
Freelance Developer
kenneth.reay@talk21.com

 

[valtersp]

I am afraid you cannot copy whole record because primary index key is set to be unique.
Why don't try to build up a set of controls with definite values (comboboxes and/or listboxes and/or textboxes) bound to fields you need to change rarely and textboxes bound to fields you have to change every time you add a new record.