synchronizing list with form

  • Thread starter Thread starter george
  • Start date Start date
G

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.
 
george said:
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.
Click to expand...


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

Forms!frmClients.ClientID
 
Back
Top