How to use a combo box in a form to show record(s) related to the chosen entry?

[Maxjoo]

Hello, every-1!!!!!!!...



I have a form displaying data for buildings. I added a command button to display a second form showing record(s) related to the building on the first form. How can I use a combo box to choose the building I want, then, display the record(s) for that building?. I was trying to search other similar questions but(aab) "I've got lost in the jungle". I respectfully and humbly request a direct answer not reference(s) to another site. Thank You in advance!!!!!

[moke123]

Set up a combobox with your building Primary key and Building name.

In your command button put

DoCmd.OpenForm "Your form name",,,"BuildingID = " & me.YourComboBoxName

the primary key is in the first column in the combo.
you can add a test for the combo being not null also

[Welshgasman]

See the DB I uploaded for another user as to one technique.
https://www.accessforums.net/showthr...t=90129&page=2

[Maxjoo]

Hello moke123!!!!...

I guess I am doing something wrong because I applied your solution, and it is not working. I have seen many similar codes and applied them with good results but this one is not working. Also, before opening this forum, I managed to get the combo box to display the list I want but(aab) when I click on any name nothing happens, it does not keep the focus...

[moke123]

Here's 2 examples of what I think your trying to do.

[abuislam]

Hello, every-1!!!!!!!...

I have a form displaying data for buildings. I added a command button to display a second form showing record(s) related to the building on the first form. How can I use a combo box to choose the building I want, then, display the record(s) for that building?. I was trying to search other similar questions but(aab) "I've got lost in the jungle". I respectfully and humbly request a direct answer not reference(s) to another site. Thank You in advance!!!!!

To display records related to a chosen building using a combo box, follow these steps:

1. Add a Combo Box: Populate it with building IDs or names.
2. Write a Query: Filter records based on the selected building ID.
3. Use VBA: In the combo box's AfterUpdate event, set the filter for the second form.

Example VBA code:
vba

Copy code


Private Sub ComboBoxName_AfterUpdate()
Me.SecondFormName.Form.Filter = "BuildingID = " & Me.ComboBoxName.Value
Me.SecondFormName.Form.FilterOn = True
End Sub


Replace ComboBoxName and SecondFormName with your actual names.

[Maxjoo]

Thank You everyone who answered my post trying to help me out!!!! After many attempts, I could make the form to work the way I wanted. Thank You abuislam for your post/help!!!…

[Rickwave]

To display related records based on a combo box selection, set the combo box to filter the form's data by linking the combo box's value to the form's record source through a query or macro. This will update the displayed records dynamically.