liste forespørgsel

Not sure what you use to change '*G*'
but one methdo is to just use an SQL in the combo's row source property instead of the query name

Then change change the property something like this

Me.YourCombo.RowSource = "Select postnr, city FROM byer WHERE city LIKE '*" & Me.SearchField & "*'"

Where me search field could be the name of a field on the form where you enter the value you want.

and the idea would be the same for a listbox :o)

... and remember to requery the listbox if it's done on-the-fly  ;o)
Me.YourCombo.Requery

Private Sub Tekst37_AfterUpdate()
Me.Liste1.RowSource = "Select postnr, city FROM byer  WHERE city LIKE '*" & Me.dit søgefelt & "*'"
Me.dit søgefelt.Requery
End Sub

Tekst27 = dit søgefelt

Så kommer der kun postnr med i listen, ikke city?

bare glem mit sidste spørgsmål, det var ColumnCount jeg skulle bruge :-)

Terry kom først med et svar og får derfor point

Thanks