Select Item in ListBox based on Control Value

[MarkA70]

I have a listbox with Column 0 set to a Primary Key. I would like to use a combo box to select a value with the Bound Column of the Combo Box being the same Primary Key as the Listbox. How do I get the Listbox to show the row of the Combo Box's value?

 

[Ranman256]

the list box query will use the combo box as its criteria.
lstbox.rowsource = "qsDataByCombo"

qsDataByCombo.sql = Select * from table where [key] = forms!frmForm!cboBox

Then when the user changes the combo, be sure to refresh the listbox in the AFTERUPDATE event.

 sub cboBox_Afterupdate
   lstBox.requery

 

[bob fitz]

You could try:

Me.NameOfListBox= Me.NameOfComboBox