copy a form

[stpmtp]

Hi,
I have a form that uses asp to be saved to an access db.
When the form is submited it creates a record. is there a way to copy a record? How would I go about doing this in asp?

 

[DotNetGnat]

need more information...your post is not clear...

-DNG

 

[stpmtp]

ok, the form is filled out for a job. Sometimes there are jobs that are very similar so instead of filling out the whole thing over. is there a way to copy a previos form and save it as a new record

 

[Sheco]

If the same data to be used on both "job" records perhaps you could just INSERT multiple records.

 

[DotNetGnat]

i am sure you are going to identify that the job is similar like that of a already filled/previous job using jobid or jobname or something like that...

what i would suggest you doing is...do a select statement using the key and if there is any record already found in the database show the form filled with the values from the database else just show the plain empty form...

post back if you need more clarification...

-DNG

 

[stpmtp]

I am not to clear DotNetGnat, let me see if I get it.
I want to copy job id #3 then I would do a select job id #3 to show me the job but how would it know to make a different record? or like Sheco said I would do an insert?

 

[Tarwn]

Basically you would take the information from record #3 and fill in the same form that you would have had the user fill in from scratch. When this form is submitted your code will add the new record with the values that you obtained from record #3 exactly as if the user had retyped all the informaiton from scratch.
You could do it without the intermediary step of filling it into the form, but this way reduces the amount of additional code you have to write and you can sell it to your users as a feature (they can now use previous jobs as templates for future jobs by copying a previous job and only modifying a couple fields)

-T