update multi records on the subform

[SSDB]

I have “animal_sales_main” as a main form and “animal_sales_detials Subform” as a subform contain one record or many records, the control object in the animal_sales_detials Subform it is field “ animal_id”
And I have a table named “animals” has fields “ animal_id” , “ status” .....etc

The target is :
When I add any records in field “animal_id” on the subform “ animal_sales_detials Subform” and click some button :

All the records in the table “animals” that have the same “animal_id “ in the subform will update the “Status” field by word “sold”
?

please, to see the attached

Regards

 

[GinaWhipp]

That form/Subform is an Invoice, so, why would there be more than one Animal ID per Invoice Detail? You are selling one Animal right?

 

[arnelgp]

you may try this.

 

[SSDB]

Dear Mr. GinaWhipp
no some time some time more than one animal for same customer

Dear Mr.arnelgp
your attached do nothing


and please to see the updated attach

regards

 

[arnelgp]

sorry for that I thought it will only be tagged "sold" when there is cash involved, anyway I change it. Try editing or adding records.

 

[SSDB]

Mr. arnelgp
you are great ...many thanks


regards