Copying Records??????

[Kieran]

I use a database to store jobs i do. Sometimes i do more than one job for a customer. Is there a way to use a macro to copy the data from a previous record to a new record to save me re-entering it all??

Please help........


Kieran

 

[JustMaybe]

don't know if this is right...but the simplest approach i would do...is to create a button in design view of your form. follow the wizard...using the options
Record Operations...Duplicate Record
When this is created name it 'duplicate'(orwhatevers logical to you) and whenever you need to copy a record..press the button!

 

[Graham T]

Kieran

It sounds as though your database may need reorganising to ensure that it is fully normalised.

You should have separate tables storing Customer information and Job information.

You can then create a main form/subform arrangement to display customers and jobs done for them.

This would cut down on having to copy information between records.

HTH

Graham

 

[Rich]

What if many of the jobs have the same detailed text Graham?

 

[Graham T]

Rich

Valid point, although storing this information in a JOBS table may ease the repetition and reduce any redundant data do you not think?

Graham