hey, i have studied this for hours and yet, i cannot solve the problem. What i have is 6 comboboxes. Now, if any of these comboboxes text values is equal to 'Any', i change the text value in then combobox to '%'. This way i can do a sql query such as:

rs.source = "select * from Cars where Car_Colour like '" & combo1.text & "'"

Now this works fine, but i then have to change the comboboxes value back to 'Any'. This then results in the rs being empty and therefore i cant movenext, moveprevious or anything else. Closing the rs before changing them back to 'Any' also clears the rs.

Has anyone got a way to keep the rs as it is when i do the query, yet still b able to change the comboboxes text back to 'Any'. Any help would be GREATLY appreciated as i'm tearing my hair out over this thanks

BIOSTALL