Cascading

Synchronize Subforms

Thanks Sandra I watched that video I tried replicating it but it didn't update when I clicked on a product, I had to first click on the product then on the price update then click update all

Thank you Dan but I'm not looking for cascading combo boxes, I'm looking to have two subforms that correspond to each other so that when I click the product subform the price update subform shows all the relevant data for that specific product for that specific supplier automatically

Have you tried putting a in the Product On Click Event either Parent!PriceUpdateSubF.Requery or Forms!MainFormName!PricueUpdateSubF.Requery? Just trying to help until one of the experts chime in.

Thank you very much for your help Sandra it is really appreciated,

I tried both and it still doesn't work, I put the statements on the subform in the left which is the form with the list of products yet it didn't update afterwards when I clicked on an Item.

Okay, this works on one of my forms.  Create an unbound textbox on the parent form and call it MasterID. Set it's control source to  

= ProductSubF!ProductID (or whatever your ID is called)

Then on the PriceUpdateSubF, go to the subform's properties (be sure to click the edge of the subform, and not the square in the corner) and under the Data Tab set the Link Master Field to MasterID, and the Link Child Field to ProductID (or whatever your ID is called).

Correction.  The right code control source for the Master ID is

= ProductSubF.Form!ProductID (or whatever your ID is called)

PERFECT WOW WOW WOW, THANK YOU SO MUCH!!!!!!!

Thank you so so so much Sandra you don't know how much I appreciate it, I've been trying out so many different things for so long and nothing helped, This really means a lot to me.

How can I tip you? Do you have way for me to?

Way to go Sandra!  I remember when this might have been one of your questions / issues.  I think Richards larnin' is rubbin off on ya.  LOL

Yonatan, your thanks is enough, I'm a student just like you.

Scott, thanks!  I'm trying and love learning.

Yeah, nice work!