Combo Box and Listing all information

[AJJ38]

Hello,

Our software was purchased with a volume license, so I want to make a combo box with all of our volume license purchases and when the person selects the volume license number all of the PCs that have software purchased with that volume license are displayed.

Below is my code

Private Sub cboVolumeLicensing_AfterUpdate()
'Moves to Volume Licensing field and
'finds records where "Volume Licensing" matches whatever is selected in the combo box
DoCmd.ShowAllRecords
Me!cboVolumeLicensing.SetFocus
DoCmd.FindRecord Me!cboVolumeLicensing
'Set value of combo box equal to an empty string

End Sub

The Query is Volume License Query and it is composed of Main Table and Volume Licensing Table connected by serial number on the main table and volume license on the volume licensing table

The combo box is volumeLicensing
And the form I am trying to do this in is called Volume License Form

Any help would be greatly appreciated. :banghead:

 

[AJJ38]

Hi Gizmo,


Yes that is exactly what I am trying to do. Whatever is selected in the combo box...all those records with that are displayed below. Thanks in advance for any wisdom you can provide