Form_Search.mdb |
Post Reply |
Author | |
A.D. Tejpal
Microsoft MVP Joined: 30 Jun 2008 Status: Offline Points: 192 |
Post Options
Thanks(0)
Posted: 08 Jul 2008 at 11:08pm |
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.
|
|
Sponsored Links | Want a good read? Try The Summer of His Life (available on Amazon!) |
Post Reply | |
Tweet
|
Forum Jump | Forum Permissions You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum |