Results 1 to 6 of 6
  1. #1
    Join Date
    Feb 2005
    Posts
    31

    Unanswered: Load 2 Record Sources into the same Form. Is it possible?

    Hello.

    Is it possible? If not, is there a way around it?

    thank you all in advance

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    2 records sources into the same form at the same time - not to my knowledge
    you can use alternate record sources consecutively, but not concurrently. You can alter the forms records sources at run time with a macro or a bit of VBA

    if you want to view both sets of records then the only alternative I can think of is to merge the data into one table

  3. #3
    Join Date
    Feb 2005
    Posts
    31
    I figured. What about Subforms, Would that do the job you think?

  4. #4
    Join Date
    Feb 2005
    Posts
    20
    depends on what you're trying to do.

  5. #5
    Join Date
    Feb 2005
    Posts
    19

    Loading 2 record sources

    Are the two record sets related ? If not each could be within a form and the two forms could be subforms. Then all you have essentially is two forms visible at the same time within a third form .

    If they are related then the normal form/subform will work. Bit confused as to what you are trying to achieve.
    Last edited by jlc@dbws; 02-08-05 at 14:17.

  6. #6
    Join Date
    Jan 2005
    Posts
    68
    if you really wanted to have two recordsources on one form why not just join the two in your recordsource query?

Posting Permissions

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