synchronizing form with listbox

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.
 
G

Guest

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).
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

filtering main form via selecting record in subform 5
synchronizing list with form 1
Combo Box Synchronizing Problem 1
Assistance with Subform Synching 9
Sorting filtered list on form with a Command Button 5
Synchronizing current record with list box 6
problem opening form 2
Loop thru form controls that match records in listbox 8

Top