>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).