Results 1 to 2 of 2
  1. #1
    igeorged is offline Novice
    Windows 8 Access 2013
    Join Date
    Feb 2015
    Posts
    1

    Question Query and form for "Customers" interested in specific "Products"

    Hello all,



    Forgive me as I am very new (built a rudimentary database for a small company with Access). I am also not sure what to search for with regards to this question so let me give you an example of what I have created and what I would like to create:

    The business I work for is a real estate business and we have certain clients associated with specific listings. I made a query that found all the people associated with a specific listing, proceeded to make a form from that query and it works great.... for that one listing (in criteria I simply put the name of the listing so it would only bring up that listing). Rather than go back to the query and change the criteria every time for the listing I am interested in, I would like a drop down box or some kind of button to cycle between all the listings.

    Click image for larger version. 

Name:	Capture.JPG 
Views:	7 
Size:	25.7 KB 
ID:	19606

    I am sorry if this is unclear, but the picture attached might help. I want to change the "listing inquired" in such a way that it doesn't change the listing associated with that client, but changes the list of people I am viewing and can then proceed to flip through all 22 (or whatever the listing has associated with it) clients via the arrows at the bottom.

    THANK YOU ALL IN ADVANCED FOR YOUR EXPERTISE!

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    49,739
    Options:

    1. use the intrinsic search/filter tools from the ribbon and right click shortcut menu
    http://support.microsoft.com/kb/304259?wa=wsignin1.0
    http://www.keystonelearning.com/reso...ilter_by_form/

    2. dynamic parameterized query http://www.datapigtechnologies.com/f...tomfilter.html

    3. VBA code http://www.allenbrowne.com/ser-62.html
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

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

Similar Threads

  1. Replies: 1
    Last Post: 09-09-2014, 11:29 PM
  2. Replies: 1
    Last Post: 09-03-2014, 03:27 AM
  3. Export "Query or Report" to a "Delimited Text File"
    By hawzmolly in forum Import/Export Data
    Replies: 3
    Last Post: 08-31-2012, 08:00 AM
  4. Replies: 1
    Last Post: 08-23-2012, 08:32 AM
  5. Replies: 11
    Last Post: 03-29-2012, 02:32 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 - Senior Forums