Populating form and subform based on search criteria

[jaishu]

Hi,

I have a form with a subform, Both of them are based on a query.the form displays a productid and its details ,and the subform has matching productnames for that productid.

Now i have a search on the main form wherein the user enters ( search for) the productid, once they click search button, the form should show that particular prod id and details and subform loaded accordingly with that productid matches...seems simple but how do i code this in VBA??

Basically populating the form and subform with data based on search..

i am using ODBC coonxn with backend oracle tables..

any help would be highly appreciated!

Thanks

 

[KeithG]

use the afterupdate event to filter the form

 

[jaishu]

can i reassign the query (the one which i used to build my query for form load) to another query and use it.??

And BTW after update of what..? sorry can u be more clear..
i can put in my code for u ..
actually the form opens up based on query, when the user enters search for the product id and clicks search what i should do for the form to display that id'd details?

itried requery with by reassigning the query (the one i use to load form on open) to use the product id in where clause, but that does nt work, hope u understood my problem

anyway thanks alot, help me to go further!