adding multiple tables as record source to a form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I already have a form created. I have about 19 tab pages on the form. I
would like to use a different record source table for each tab page. How can
I do this?
 
Place a subform on each tab. Each subform can have its own RecordSource.
They don't need to be linked to each other or the Parent form, they can
operate independently. The problem you're going to run into is that this is
going to be VERY slow to load. There are some ways around this, such as
assigning the subform to the subform control the first time you move to that
particular tab. This doesn't hurt anything since it won't be visible anyway
until you go to the tab. Also, with that many forms loaded at once, you may
run into performance problems depending on the computer's hardware
capabilities.
 
Back
Top