Hi ther Karol!
A couple of tips for you first off:
1) Combo7 is not a ncie name for a control, is it? It tells the programmer (i.e. you and any future devs) anything useful about what this control is, let alone what it does! Same goes for your other control names - try make them linked to their purpose/meaning so that your code becomes more human readable!
2) how do you wish to display your results? Different controls have different methods of showing results!
Ok, now that's out the way, on to our pseudo solution (using a listbox)
Dim strSQL As String
Dim strWhere As String
strSQL = "SELECT * FROM MyTable"
strWhere = " WHERE CriteriaField = '" & Me.Combobox.Column(n) & "'"
'-- Note that n is used to denote the index of the column you wish to use from your combobox
Me.MyListBox.RowSource = strSQL & strWhere
You may (will
) want to have a read of this
to learn the basics of SQL!
If you have any questions just post them back her.
Hope this helps!