"SELECT * FROM meineTabelle WHERE meinDbFeld=" & Me.meinFormFeld.text
'Requery am Grid nicht vergessen

Dim strWhereKlausel as String
strWhereKlausel = "meinDbFeld =" & Me.meinFormFeld.text
meinRecordset.Filter = strWhereKlausel

Debugging is twice as hard as writing the code in the first place. Therefore, if you write the code as cleverly as possible, you are, by definition, not smart enough to debug it. (Brian W. Kernighan)