query question for listbox

  • Thread starter Thread starter John
  • Start date Start date
J

John

I have a mainform that has a tab control on it. On the
tab control there are 5 pages. Each page has a different
subform on it. Each successive tab is dependent on the
prior information. An example of the first 2 tabs is;

tab1 is ClientInformation subform

tab2 is ClientLocations subform for the locations
associated with the selected client in ClientInformation.
Tab2 is linked to tab1 thru ClientInformationID.

On tab2 there is a listbox that I would like to display
the locations in that are associated with the selected
Client in tab1. I've been able to get all locations for
all clients to show but not able to show only the selected
locations.

I tried using the query design but I'm missing something
in it that breaks it down to the needed locations. What I
have in the design is;

ClientLocationID (bound column, zero width)
LocationName
LocationNumber
LocationContact
ClientInformationID (zero width)

Can anyone see what else there is needed in the query?

Thanks. John
 
Please disregard as I finally figured it out.
Thanks for looking at the posting.
.... John
 
Back
Top