Access subforms - best performance

[voyagr12]

What is the method, performance wise, of linking subform to parent form.

Should I use the built in 'Link Master/Child Fields' as can be set from the subforms properties sheet.

or should one use a query for the subform that is only returning the results based on the selection made in the parent form.

or programmatically set the record Source of the subform based upon selection made in the parent form.

or does it not matter from a performance standpoint. Is the built in 'Link Master/Child Fields' effectively creating a query for you automatically?

thanks in advance.

 

[RuralGuy]

The simple answer to your question is YES. Use the built in LinkChild/MasterFields properties.

 

[Galaxiom]

The Link fields are the way to go. Either way only shows the results necessary to fill the screen until you scroll down.

The important preformance element is to index the fields in the table that are used for the Link or Where clause.

 

[voyagr12]

I am using this access database with SQL Azure and just want to make sure I am doing the best option for performance. I want to get as little information from the server as possible to maintain the greatest performance possible. I want to make sure that not only am I only showing the results wanted, but that I am also only retrieving the results wanted.

thanks,