updating several records at once

[davidf]

hello I have a database I created. its has Units, then it has Tracts and under tracts it has Leases. the main form is for the units. then I have a sub form which is tracts. in the tracts there is a field for Leases Vol/Page. everything works great. now I have a client that wants to send me Title opinions which are for several of the leases in the tract sub form. I need to input the info in a form and have it saved in fields in each Lease at one time. right now I have to goto each lease and insert it every time one by one. the field for each lease is the Vol/Page field. is their a way I can do this without having to goto each lease one at a time.??????? in other words one title opinion might be the same for ten of the leases I need to update these all at once.
Thanks for your help
davidf

 

[Pat Hartman]

As long as you have criteria which can be used to select the records you want to update, you can write an update query. I would create a separate form for this process that lets you enter the criteria and the values for the fields that will be updated.