synchronizing form with listbox

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

george

Hi to all,
I have I main form with a text box, ClientID, on it and a
command button which opens another popup form with a list
box on it. One of the columns in the list box is ClientID.
I have filtered the list box so that it displays only
pertinent info to the client on my main form but I cannot
synchronize it with the main form, ie when I move to
another client to see pertinent info in the list box. How
do I do this?
Thanks a lot in advance, George.
 
The easiest way to do this is to create query like that
SELECT * FROM CLIENTS WHERE CLIENTS.CLIENTID = & Forms!Main!ClientID &
This query must be rowsource for your listbox
Every time, when you open popup form your listbox will display selected records
Make sure your popup form is Dialog (has focus as long as is open).
 
Back
Top