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.
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!