Forms folloiwng query

[BorisGomel]

Hello everybody,

I have two big tables called Cap Nan and Cap Client and I was given a task to compare them by dates and code ( can be 001,002 until 050) .I have created two queries called Cap Nan Firm and Cap Nan Client off these tables. Then I created form (frmInquire) on which I put text box -txtDate and list box lstCode and typed in fileds code and dates in both queries Like [FORMS]![frmInquire]![lstCode] & "*" and Like [FORMS]![frmInquire]![txtDate] & "*" .It is working ok . Once a user types dates and select codes off the list boxes, then click command boxes ether to run Cap Nan Firm or Cap Nan Client and the queries are ran ok. The problem is that results of queries should be seen thorough forms . I created two forms called frmCapNanFirm and frmCapNanClient off queries, then I inserted these two forms onto major from frmInquire and can not figure out how to show result of queries thru the forms and not queries showed by themselves.
Thank you in advance for advice
The Best Regards,


BorisGomel

[Robeen]

I think what you need to do is research Subforms and then set your Main Form & Sub form up according to the information on the following page:
http://office.microsoft.com/en-us/ac...005187803.aspx
Hope this helps!