I don't understand "form might have 30+ tables and 25+ queries" -- could you
clarify?
A bound form can have exactly one RecordSource plus RowSources for Combo or
List Boxes, plus a RecordSource for each Form embedded in a Subform Control.
A single form with that many tables and queries would seem to me to be so
"busy" that it would not be usable.
Larry Linson
Microsoft Access MVP
"Jeremy Campbell" <jc***********@hotmail.com> wrote in message
news:15**************************@posting.google.c om...
I am creating a master form that users can hit a command button to
direct them to a form of their choice. How can I link to the seperate
databases where the forms are stored. Each form might have 30+ tables
and 25+ queries, not to mention the macros, ect. I don't want to have
everything in the same database for size concerns. How can I have one
database that can link to all of the other databases?