troubleshooting Question

Use multiple tables as Listbox source

Avatar of fyrerose
fyrerose asked on
Microsoft Access
10 Comments1 Solution339 ViewsLast Modified:
Is it possible to use multiple linked tables as the source of one listbox?  

I've linked the following tables in my database in order to provide a quick way of searching for accounts in several locations.  (

TABLES

Financial Pacific March 2005 Review
Financial Pacific Due Diligence Review
Financial Pacific August 2005 Review
Advance Limit Apporval

What I'd like to do is see the source of the listbox (which is part of a search form I have in place already) be dynamic in a way that it updates automatically if there are any additional records added to the above tables.  

In order to get the search box working I created a new table in the database and appended the records from the other tables to it.  That won't work in the long run though.

As always any help is greatly appreciated.

Rose Marie
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 10 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 10 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros