Eric,
Can u give me some code Pls.?
>>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).
<><><><><><><><><><><><><><><><><><><><>
<><> REMEMBER,,,,KNOWLEDGE IS POWER <><>
<><><><><><><><><><><><><><><><><><><><>