Results 1 to 2 of 2
  1. #1
    daniel.ru92 is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Mar 2013
    Posts
    20

    Little help with search command


    Hi everyone, I almost finished build my database but I have little problem - I want to add a subform in my customer form, where the user can type whatever he knows about the customer (first name, last name, phone number, street, house number) and when he will press the command button, it will run search on the table of the main form (customers) and jump to the correct customer. If the customer doesn't exist, it will pop massage "not found".
    I thought to do that via query, because I want it to combine some searches (example - user know only first name and street), so it will be very simple, but I don't want it to open new page with the result, but to jump to correct customer in the customers form...
    Thank you!!

  2. #2
    burrina's Avatar
    burrina is offline VIP
    Windows 7 64bit Access 2010 64bit
    Join Date
    Oct 2012
    Location
    Freeport,Texas
    Posts
    1,383
    Just use a combobox for this. Why would you need subform for this? Makes no sense.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Search Command
    By djclntn in forum Reports
    Replies: 3
    Last Post: 01-05-2013, 09:09 PM
  2. Replies: 10
    Last Post: 10-19-2012, 10:16 PM
  3. Replies: 1
    Last Post: 03-19-2012, 11:03 AM
  4. Search Command
    By Meccer in forum Reports
    Replies: 11
    Last Post: 04-12-2011, 01:31 AM
  5. Replies: 8
    Last Post: 02-19-2011, 05:48 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums