Results 1 to 2 of 2
  1. #1
    2 Star Lounger
    Join Date
    Apr 2001
    Location
    Melbourne, Australia
    Posts
    118
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Sub table (Access 2000)

    Hi Everyone,

    I am trying to setup a database and am having difficultly with sub formtables.
    I am in design mode of a form and am using the subform/subreport button to add a table with linked information.
    My problem - when I use this button and follow the wizard, it only lists the forms I have created not tables.

    Am I using the correct button?

    Thanks Kindly

    Kerrie <img src=/S/smile.gif border=0 alt=smile width=15 height=15>

  2. #2
    Star Lounger
    Join Date
    Dec 2001
    Location
    Birmingham, Alabama USA
    Posts
    95
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Sub table (Access 2000)

    When the Wizard appears .... there are two radio buttons. If you choose "Use an existing form", you choose a form from the list below.

    But you want to use ..... "Use existing Tables and Queries". Click this option, then click the "Next" button near the bottom. The next form is where you choose the Table or Query from the ComboBox entitled "Tables/Queries".

    HTH
    RDH
    Ricky Hicks
    Microsoft MVP
    Birmingham, Alabama USA

Posting Permissions

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