hello everyone. im getting the error: "run time error 3061 - too few parameters. expected 2" when using a select query. i have the following code:

dt.recordsource="Select * from Table_Name WHERE Field1 like '" & combo1.text & "' AND Field2 like '" & combo2.text & "' AND Field3 like '" & combo3.text & "'"
dt.refresh

if i use the following, it works great:

dt.recordsource="Select * from Table_Name WHERE Field1 like '" & combo1.text & "'"
dt.refresh

so i guess i use wrong syntax after 'WHERE' parameter.

thanx in advance guyz