Results 1 to 4 of 4
  1. #1
    Join Date
    Oct 2006
    Posts
    8

    Unanswered: Tabbed form record source...

    Good morning,

    I an running into a road block that I hope you can help me with.

    My application has several forms that I would like to consolidate into one form with multiple tabs. The problem that I am having is that is seems I can only have one record source. I can place one of my forms in the first tab without a problem; when I try to create the contents of the second tab I can not find a way to use the record source for the second form.

    Any idea's?

    Thanks for your help,

    Ron

  2. #2
    Join Date
    Nov 2004
    Location
    Harrogate, N.Yorks, UK
    Posts
    83
    Create your tab control on a form (without a record source if needs be). Each of your forms should then be placed on the tabs as subforms which each have their own record source.

  3. #3
    Join Date
    Oct 2006
    Posts
    8
    Thankyou for your help

  4. #4
    Join Date
    Jun 2005
    Location
    Richmond, Virginia USA
    Posts
    2,763
    Provided Answers: 19
    Or if create a query to use as your form's source that includes all the tables you need, assuming all the tables are related in some way.
    Hope this helps!

    The problem with making anything foolproof...is that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •