update a table from a form

[Guest]

I've created a query and included all the fields from two tables, but have
hidden the ones I don't want to see on the form. The form updates the 2nd
table by inserting a new row, but I want it to update a row that's already
there. e.g. Table one contains vehicle details, with the registration number
as the primary key. The second table includes service records, with a
serviceID as the primary key. Ihave linked the two tables together using the
registration number. I want to update a field in the vehicle table (next
service date) that corresponds to the registration number entered on the
form. Any ideas?

 

[Wayne Morgan]

This sounds as if you want a form/subform setup. The main form would have
the information from the Vehicle table and the subform would have the
information from the ServiceRecords table. The subform has a link that can
be set to synchronize the two forms (Master and Child link properties). You
would then be able to edit the Vehicle table's data in the main form and the
service date in the subform. You would use two different queries, one for
each form.