how to refresh/requery subform?

[merlin777]

i have a form which contains a subform containing a query. two controls on the main form allow the user to enter parameters for the query but it doesn't update. i understand you need to requery the subform.

it would be good if it could requery after a new value has been entered but a 'refresh' button would do.


how wouldi go about that (pref without vba)
tia

 

[ranman256]

Use a button if they can change many controls. (usu 1 line of VB is needed...not full pages of code)
after all the changes, Use the BUILDER (the magic wand icon with elipsis) to make references to objects: forms!main!subform!form.requery
(notice the extra 'form')

 

[merlin777]

so i need a little bit of vba for a button. Where doesforms!main!subform!form.requery go? is this the vba you mentioned or a way of refreshing without a button?

 

[ranman256]

In whatever control you use to change values. If its only a combo box, it would go in the combo afterupdate event.
but if you have >1 control, you would need a button (to know when the user is done) so it would go in the button click event

 

[merlin777]

many thanks