Hi,

   I know this must have been covered a thousand times... I have three tables: tblMain, tblJurisdiction, tblBuilding. The tblMain has a look up to tblJurisdiction, and a look up to tblBuilding. tblBuilding also has a look up to tblJurisdiciton since we have several Jurisdictions, and within those Jurisdictions there are several Buildings each. Perhaps tblMain only needs to look up tblBuilding since the Jurisdiction issue will be covered through the tblBuilding look up to tblJurisdiction.

   I have a form that uses tblMain, and I would like users to be able to select a Jurisdiction in a combo box (no problem there) and then based on the Jurisdiction they selected, have a limited selection in a list box of Buildings in that Jurisdiction. They should be able to select more than one Building.

   Thanks in advance...

mmcdonal

mmcdonal

__________________
mmcdonal

Look it up at: http://wrox.books24x7.com

Have the RowSource for your Building based on the Jurisdiction Combobox, and requery it when Building is changed.
For example, on the AfterUpdate event of the Jurisdiction Combobox (named cJurisdiction here)
There's more elegant ways to do it, but that's the best way I can describe it using code only, and at this time of the day

Steven

I am a loud man with a very large hat. This means I am in charge

This was a clear and direct answer to your question. If you don't understand it- that doesn't make it vauge.


Hal Levy
Web Developer, PDI Inc.

NOT a Wiley/Wrox Employee