Dynamic link between 2 forms

[geocan2006]

I have 2 forms open 1st for data entry 2nd for data search, the data search is linked to data entry form in Control Source, however only the On Click event gets the data form data entry, what is the solution to do it as I type, On Change dont do it.



VB running

Private Sub search_Click()
DoCmd.Requery "search subform"
End Sub

A template would be nice

Thanks

[ranman256]

the 2 forms should be looking at the same data. 1 to enter, 1 to search on the same table.
the search should just open a query with the item(s) filled in,
or
the search should show all records (continuous form) then filter on the item in the search box.

[geocan2006]

Both forms looks to the same data (Table)
The search form is a sub-form
Thanks