Subform displaying information based on form's current record

[PepeGallo]

Hi folks!

I have a form that has a subform. This subform gets its data from a query that returns the data of all customers. When I run the form, the subquery displays the data from all customers. I don't want it to work like that, I want to display in the subquery only the data related to the current customer being displayed in the form. How can I do this? Thank you

 

[pbaldy]

Look at the master/child link properties of the subform control.

 

[dsfcom]

Yes...the tables should have one or more fields that are common; then you create the link(s) between the form(s) using these field(s) and only related records are displayed.

 

[PepeGallo]

Oh, thank you so much guys, it worked perfectly.