Unanswered: Open Form with Specific Data in Listbox
I am trying to open a form from another form and only specify specific data. However, I am having problems as the data I am looking to be specific in the second form is in a listbox and this seems to be causing troubles.
In the 1st form I simply have a combo box and command button. When you click the button it opens the 2nd form with the criteria set in the combo box. This is the code for that:
Dim stDocName As String
Dim stLinkCriteria As String
stDocName = "frm_display_contacts"
stLinkCriteria = "[Interested in:]=" & "'" & Me![Interested_Combo] & "'"
DoCmd.OpenForm stDocName, , , stLinkCriteria
However, as the data I want to specify is in a listbox in the 2nd form, this currently doesn't work. How can I change the code so it filters the listbox and not the form itself?