Hi, I have database containing mailing jobs we do. There are occassions where there are multiple records that correspond to one big job. Staff sometimes need to be able to 'copy down' data from one record to others. In excel it is easy to do this via copy and paste, but in access it is not so easy.
What I have so far is a continuous form where the user first selects the jobs that correspond with each other by ticking a checkbox.
This then opens another continuous form that has a datasource with a query based on the ticked checkboxes so they only have the jobs they want to update in front of them.
Some of the fields will be the same for all of those jobs so I need a way they can enter the information in the top row and then either automatically or by clicking a button will copy that information to all the other records. So far I can only find a way of copying information within the same record, not from one record to another.
Any ideas on how to do this?
Thanks