Creating a subform

[browny]

Hi all
Simple problem I'm hoping someone can help with. I have a form that is populated using a query that looks up a table called tblFleet. I can search the query results using a simple search function I downloaded from this site(See previous thread). What I would like to do now is display results from a linked table, tblVCR that match the fleet vehicle I select on the main form. I tried inserting a subform but could not get it to return any results. Do I need to create a separate query to return the reults into the subform or is there code that I need to add.
As always, any help appreciated
Regards
Craig

 

[aleb]

Not sure why you could not set the subform return the related records. Once you insert the subform mainform is turned into a single form from continues form. On the properties of the subform there are: link childfield, link masterfield. Those two fields is used to relate one set of data to another. ( Unless of course your table are not related at all to each other )