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 - 21 Jan 2008 17:37 GMT
On the After Update event of your combo box put the following:
[Forms]![frmMainForm]![sfrmSubformName].Requery
Hope this helps,
Jackie
> 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].
[quoted text clipped - 13 lines]
>
>