combo

[Maran]

have placed a subform, which gives the Price. It is based on the Query. I
have given a criteria in the query like [forms]![mainform]![productid].



So, when I select a product from a combo box, on the main form, I should see
the price on the subform. The problem, is it does not refresh. It still shows
the same price for the earlier product. But, when I move, it gets refreshed.



Can I have a code , so that I should see the price as soon as I select the
product from the combo box .

 

[Jackie L]

On the After Update event of your combo box put the following:

[Forms]![frmMainForm]![sfrmSubformName].Requery

Hope this helps,
Jackie