Question on to filter or to requery subform (1 Viewer)

[helper11]

Hi all,

I am wondering which would be quicker. I have a combo box where a value would be selected. Then I would either have it requery a query to fill in the subform or to create a value and filter the subform and display it. Which would be faster as the record size grows?? I have created both and dont see much difference when I have 5000 records but wonder when it gets bigger how much this would change.

Thanks for any info...

Andrew

 

[Galaxiom]

Another way is to include the combobox in the MasterLinkField property of the subformcontrol along with the main recordsource fields that link the subform to the main form.

The field to be searched is included in the matching location of the ChildLinkField property.

This requires no coding at all as the requery is automatic. I find it works very fast. For best performance be sure to index the field being searched.

 

[helper11]

Hello,

Sorry for taking so long to get back to you. That is a great idea I will have to look into that in the future...

Thanks again.