How to update data in form from pop up form

[hmho]

I attached data sample
I Have continous form [FrmDailySales] where I enter product sales and there is field name [Status] which has five different statuses. When I enter product if the status is InStorage I like to open Status form while still in the sale form and update the status to OnShelf and at the same time update the sale form to reflect this change. I was able to add Button to open the Status form but I need help how to update the sale form at the same time.

Thank

 

[Galaxiom]

Add the other actions to the open form procedure.
DoCmd.RunSQL is a fairly easy command to set up and covers most requirements.

Those inexprerienced in SQL can build the procedure in the query designer and copy it from the SQL view.
Otherwise store the query and run it with DoCmd.OpenQuery

 

[hmho]

I'm not sure how to do that.

Thanks