Carnegie23

[Guest]

I am an Access novice and am having trouble creating a specific filter. In form view, how can I select a specific building in one combo box and have the next combo box , "aparments", show only those apartments in the selected building?

 

[Van T. Dinh]

See The Access Web article:

<http://www.mvps.org.access/forms/frm0028.htm>

HTH
Van T. Dinh
MVP (Access)

-----Original Message-----
I am an Access novice and am having trouble creating a

specific filter. In form view, how can I select a
specific building in one combo box and have the next combo
box , "aparments", show only those apartments in the
selected building?

 

[Arvin Meyer]

I am an Access novice and am having trouble creating a specific filter.

In form view, how can I select a specific building in one combo box and have
the next combo box , "aparments", show only those apartments in the selected
building?

Code the AfterUpdate event of the first combo something like this:

Sub cboBuilding_AfterUpdate()

Me.cboApartment.Rowsource = "Select ApartmentNumber From tblApartments Where
BuildingNumber =" & Me.cboBuilding

End Sub

Of course, you'll need to substitute your field and control names.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access