How to pass result from a query to be display on the sub-form where the query is perform on the same form? E.g like when I enter a value into field1 and upon update, the query will run and the result will be display in the subform directly..

Thanks for all the help
Justin

After update, requery the subform. The subform has the query as its recordsource.