Sending s filtered query using SendObject

[William A. Huntley]

I am trying to send query data specific to individuals using
DoCmd.SendObject.

I don't want everyone to get all the data in the query, just that specific
to each person. Each person could get multiple records of data that only
pertain to them. How do you go about this? I was looking for a way to send
an SQL query would would take care of this without being prompted via a
parameter in the query?

I was thinking about creating a query for each one programmatically, saving
the query, then sending it for each person in a loop. This seems very
verbose.

TIA!