On Mon, 14 Jun 2004 18:25:58 -0700,
wrote:

I need to set the parameter value, and requery the
subform, every time the parent form navigates to a new
record. Can this be done in code? The value of the
parameter is a field that is available in the parent form.

Just use that control as (part of) the Subform's Master Link Field,
and the field that it is searching as the Child Link Field. Or,
explicitly reference the form control in the parameter:

=[Forms]![yourformname]![controlname]


John W. Vinson[MVP]
Come for live chats every Tuesday and Thursday
http://go.compuserve.com/msdevapps?loc=us&access=public