| | |
|
|
|
Carnegie23 |
|---|
| message from =?Utf-8?B?RmlsdGVyIGJ5IHNlbGVjdGlvbg==?= on 30 May 2004 |
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 replied to =?Utf-8?B?RmlsdGVyIGJ5IHNlbGVjdGlvbg==?= on 30 May 2004 |
http://www.mvps.org.access/forms/frm0028.htm
HTH
Van T. Dinh
MVP (Access)
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 replied to =?Utf-8?B?RmlsdGVyIGJ5IHNlbGVjdGlvbg==?= on 30 May 2004 |
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.
|
|
Archived message: Carnegie23 (Microsoft Access Forms)
