Update ?

[PAUL@FPC]

I have two tables linked to two forms, 1 Customers 2 Orders the key fields are Customer ID and Order ID. my problem is that i want the order form to update the data in the corresponding table without first closing the form.

could anyone give me some guidance?

 

[PAUL@FPC]

Update?

Thanks that little bit of code works a treat