Set field value on forms

[Jengminchen]

I have a video rental form/subform. Video products have a field called status. Everytime someone hires a video I want it to be automatically updated to "Out" I have try to write a code so that when a video is selected in the subform the underlying field 'status' in the product table will be updated as well to 'out'
How can I do this. I need help urgently.

 

[Jack Cowley]

Create an Update query and run the query when you dbl click, or whatever you do, to select a record in the subform.

hth,
Jack

 

[Jengminchen]

Update queries

Thanks a million to you both, Jack and Pat. Much appreciated.
I have figured out your simple suggestion Jack and it worked fine now. However in trying to execute Pat idea, I am completly lost as the queries update the Rented To fields on Product tables for all customers instead of just one. There are four tables in all, Customers, Rentals, Rentals details and Products. Any suggestion on how to achieved this will be much appreciated as I am only a beginner.

 

[Jack Cowley]

Your Update query has to have the ID of the customer in the criteria line so that it only updates that record. You can look in help for how to use criteria in your query...

Sounds like you are almost there so good luck!

Jack