Roger's Access Library Homepage
Forum Home Forum Home > Other Download Libraries > MS Access MVP Libraries > Tejpal, A.D.
  New Posts New Posts RSS Feed - Form_Search.mdb
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

>
Want a good read? Try The Summer of His Life (available on Amazon!)

Form_Search.mdb

 Post Reply Post Reply
Author
Message
A.D. Tejpal View Drop Down
Microsoft MVP
Microsoft MVP


Joined: 30 Jun 2008
Status: Offline
Points: 192
Post Options Post Options   Thanks (0) Thanks(0)   Quote A.D. Tejpal Quote  Post ReplyReply Direct Link To This Post Topic: Form_Search.mdb
    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.

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

--

Email: adtejpal@gmail.com
Back to Top
Sponsored Links
>
Want a good read? Try The Summer of His Life (available on Amazon!)

Back to Top
 Post Reply Post Reply
  Share Topic   

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.03
Copyright ©2001-2019 Web Wiz Ltd.