Eric,

This is excellan, but what i don't understand is , the record set is already opened.
should I reopen it with your SQL statment when the user select the data ?


>>Eric,
>>
>>Can u give me some code Pls.?
>>
>
>You should have a command button on your form to let the user retreive data? If we take the query you had in your original question, it should be modify to look like this:
>

>strSQL = "SELECT * FROM unit, unittype, estate" & _
>         "WHERE untestateidno = estateid " & _
>         "AND unttypeidno = unittypeid " & _
>         "AND Combo1Field = '" & combo1.text & "' " & _
>         "AND Combo2Field = '" & combo2.text & "' "
>

>
>
>
>
>
>>
>>>>Could you please advice me how to issue the Where clause (BUT) after making the Recordset same as the code I posted above.
>>>>Meaning ... After I issue the code above I open the form then the user has to select the data from 3 ComboBox, then I'll take the selected ComboBox values and make the search in the current record set and find the record matching the 3 selected values. (I think it's like firing another where clause for the current Select statment with the current Where clause).
>>>>
>>>>Highly appreciate it...
>>>
>>>Don't query your database until you have all your requirements (ie your 3 combobox filled).