<div>
In the combo box's AfterUpdate event, write VBA code that goes something like this...<br />
<br />
Private Sub YourComboBox_AfterUpdate()<wbr /><br />
<br />
Me.MySubformObjectName.For<wbr />m.RecordSo<wbr />urce = &quot;SELECT goo, foo, boo FROM U2 WHERE Equipment=&quot; &amp;&nbsp;Me.YourComboBox<br />
Me.MySubformObjectName.For<wbr />m.Refresh<br />
<br />
End Sub<br />
<br />

</div>


<div>
Is the main form a bound form (showing equipment details?) or is it just a container for the subform?
</div>


<div>
Thank you this was very helpful
</div>


<div>
... and my answer was not good ... how exactly?
</div>


<div>
<div class="content wysiwyg-content">
I have a form with a combobox that has a list of equipment. What I want is when the user chooses an equipment, the subform is populated with all the maintenance reports for that specific equipment. The reports have a field with the equipment name. <br />
<br />
Thank you. 
</div>
</div>


I have a form with a combobox that has a list of equipment. What I want is when the user chooses an equipment, the subform is populated with all the maintenance reports for that specific equipment. The reports have a field with the equipment name. 

Thank you. 

Populate a subform based on a combobox

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.