This question probably advertises my ignorance, but I'm trying to make sure
I have as efficient as possible db app. for multiple users and network
traffic, etc.

I have a split db, with front end on every user's PC, and back end on shared
folder.  I'm putting in all kinds of "click on this field to open another
form with related data about that record" stuff on the forms.  I'm wondering
which is more efficient (or if there's a difference):

- Using a separate query whose one field (the one clicked on in the first
form) is set to = the 1st form's field value, thus populating the second
form with related data

OR

- Using a Where condition in the button's OpenForm event to filter the
second form's data

So, the record source for the 2nd form would either be a query specific to
that 2nd form, or a table (or larger, more universal query) whose results
are filtered using the Where Condition in the DoCmd.Openform line.

Any advice is appreciated on this, and thanks for reading.