Hi

I will like to find out whether it is possible to re-query a text field of another form after I click add on my current form.

The scenario is like this. I have a Purchase form and I there is a drop down list to search for items to purchase. If the item does not have a selling price, they will be prompted to add a new selling price if it does, it will just display the selling price in one of the text field. I will like to make the selling price text field re-query if a new selling price is added so as to display the new amount.

Please advice. Thank you in advance.

Just fully reference the control in the other form in the VBA.

In the AfterUpdate procedure for the textbox where you add the price:
Forms!formname.textboxname.Requery