Form_Search.mdb

This sample db demonstrates search results with following interpretations of 
values entered in unbound cascaded combo boxes:            
        (a) " ALL" 
            No filter for the field in question.
        (b) Some specific value
            Show all records where the field in question has exact match for this value.
        (c) Some specific value having Wild card prefix and / or suffix.
            Show all records after applying Like operator with wild cards, for finding 
            matches with the field in question.

The results are displayed in a subform and get updated as soon as a new value is
 entered in any of the combo boxes.

It takes advantage of the fact that the outcome of Like operator without wild cards 
is equivalent to that of = operator.

When making a direct entry in the combo box (by typing), if the previous existing 
value happens to be " ALL", make sure to overwrite the complete contents, 
including the space prefix.

Download Access XP (A2K format): uploads/37/Form_Search.zip