synchronizing list with form

[george]

Hi guys,
I have a form, frmClients, with a command button on it
which opens another dialog form fdlgPolicies.
This second form contains a listbox, lstPolicies, which in
turn is based on an embedded query. Currently when I click
on my command button, fdlgPolicies opens but displays all
policies of all clients in the list box. I want it to
display only those policies which belong to the client
that I'm viewing on my frmClients. How can I synchronize
the two?
Any help will be appreciated.

ps: There is a field ClientID on my clients form, and
ClientID, PolicyN in the query behind the list box.

 

[Marshall Barton]

Hi guys,
I have a form, frmClients, with a command button on it
which opens another dialog form fdlgPolicies.
This second form contains a listbox, lstPolicies, which in
turn is based on an embedded query. Currently when I click
on my command button, fdlgPolicies opens but displays all
policies of all clients in the list box. I want it to
display only those policies which belong to the client
that I'm viewing on my frmClients. How can I synchronize
the two?
Any help will be appreciated.

ps: There is a field ClientID on my clients form, and
ClientID, PolicyN in the query behind the list box.

I think you can just add a criteria to the list box's
RowSource query. Under the Client ID field, use

Forms!frmClients.ClientID