you misunderstood me.

i want to convert this query to a stored procedure.

S="SELECT * FROM tblUsers WHERE field1=1"

if combo1.listindex>-1 then

s = s & " AND field2=" & combo1.text

end...