subform top requery on textbox update

[Hammondo]

I'm trying to get a Subform (that is based on a query) to update (requery) automatically when a new value in a textbox on the main form is updated.

On the update of the textbox, the subform should read the value contained in the textbox using it as a query parameter for the record it is to return...

Can anyone help!?

 

[Taff07]

Assuming that you have everything correctly setup initially then you just need to use the following line of code in the After_Update event of the text box.

me.Subform.refresh

replace Subform with the name you gave to your Subform control. (Not neccesarily the same name as the subform itself.)

Hope this helps

Ian

 

[Kolinu]

Run an "On Exit" event procedure for the text box calling to requery the subform

DoCmd.requery "nameofsubform"