Results 1 to 1 of 1
  1. #1
    Join Date
    Jul 2006
    Location
    Manila, Philippnes
    Posts
    17

    Unanswered: Help with Search function

    hi guys... i am currently working on a search form for my database.. here's
    how my form looks like:

    http://i114.photobucket.com/albums/n...clientform.jpg

    when the user will type in for example "EOT Corp." in the "Search for" field
    and will choose "Company Name" in the "Search by" combo box, the database
    will look for all the "EOT Corp." entries under the field of "Company Name"
    in a table. The options under the "Search by" combo box will come from different tables... Not only from tblCompany.

    the results should be shown in another filled form like this:

    http://i114.photobucket.com/albums/n...oyeeform-1.jpg

    does anyone has a sample VBA code for this function? i've been searching for
    it, but unfortunately i wasn't able to find what i was looking for. thank you
    very much. all your replies would mean so much.

    if you want, you can also check the actual ms access file:

    http://www.gigafiles.co.uk/files/636...2006-09-27.zip

    thanks a lot... =)
    Last edited by lushh; 10-09-06 at 02:46.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •