Results 1 to 2 of 2
  1. #1
    2 Star Lounger
    Join Date
    May 2002
    Location
    Jerusalem, Israel
    Posts
    187
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Subform on Continuous Form (Access 2000)

    Hi there. I have two forms that run off two separate tables. One of the forms is a continuous form and contains the customer information. The other form contains a list of sales projects and the name of the person who is in charge of the sales project.

    Now I want to insert the name of the salesman in charge of the project onto the continuous sales information form (linked by the sales project/sale item, which is the same). The only thing is that Access does not allow me to add a subform onto a Continuous Form. How can I still display this information? Would it be possible to do this using a text box and then insert some code to link the sales item in the Continuous Form with the salesperson in the second form so that it displays the correct information?

    Thanks,

    JoeK

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Subform on Continuous Form (Access 2000)

    Perhaps you can create a query based on the two tables that adds the name of the salesman to the sales info, and use that as record source for the continuous form.

Posting Permissions

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