Results 1 to 5 of 5
  1. #1
    Join Date
    Jun 2008

    Unanswered: help me design this Find form

    i have a table which has Name+phone_number as PK. now i need to build a form where one enters a name and presses a button. All records having that name in the Name field shoud be displayed in a subform. please help me out here..

    A soln which i though...
    i build a query which takes the criteria for Name field from the form i create.. and returns all the record to the form. The part i dunno is.. how does the query takes the criteria dynamically from the form. If this solution cannot work please suugest some other soln.

    please help..

  2. #2
    Join Date
    Nov 2007
    Adelaide, South Australia
    You can put in a criteria for the query such as:


    BTW I would be dodging a fieldname called Name, since it is a reserved word.
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!

    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  3. #3
    Join Date
    Jun 2008
    thanx and thanx for the advice as well..

  4. #4
    Join Date
    Jun 2008
    i need something like this
    suppose there are three records with names vikash, vikash gupta, vikash sharma
    if i type vikash and press ENTER i get only 1 record from the table and the query automatically changes the last entry to vikash
    also vikash* wont work...
    how can i make vikash* work and stop this form from editing the last entry

  5. #5
    Join Date
    Jan 2007
    Provided Answers: 12
    Change the equal (=) comparison in the query to be a LIKE comparison, then you can use the wilcard (*)
    Home | Blog

Posting Permissions

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