Results 1 to 6 of 6
  1. #1
    3 Star Lounger
    Join Date
    Dec 2001
    Location
    Schenectady, New York, USA
    Posts
    273
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Restore form (Access 2000)

    The wizard created a query that contained the two table but only selected the fields that you requested for the form. Find the query that was generated and just add the field from the table you want into the query.
    Don
    <img src=/S/flags/USA.gif border=0 alt=USA width=30 height=18> <img src=/S/flags/NewYork.gif border=0 alt=NewYork width=30 height=18> "Life on Earth is expensive, but at least it includes a free trip around the Sun."

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

    Re: Restore form (Access 2000)

    Click in the Record Source property of the form (in the Data tab of the Properties window), then click the ... on the right hand side of this property. This will open a query builder window. Add the field(s) you need to the query design grid, then close the query builder window and confirm that you want to save changes.

  3. #3
    5 Star Lounger
    Join Date
    Feb 2001
    Location
    Australia
    Posts
    676
    Thanks
    28
    Thanked 2 Times in 2 Posts

    Restore form (Access 2000)

    I created a form using the wizard, including fields from three tables. Later I needed to add another field from one of the tables, but the field list only contained the fields that I selected using the wizard, so in the form properties I selected one of the tables as the record source, which enabled me to add the new field from it, but then all the fields from the other two tables displayed #Name?. Now I can have one table as the record source but not all three as I had originally after creating the form using the wizard. How can I restore the form so that all the fields from all three tables are included again?

  4. #4
    5 Star Lounger
    Join Date
    Feb 2001
    Location
    Australia
    Posts
    676
    Thanks
    28
    Thanked 2 Times in 2 Posts

    Re: Restore form (Access 2000)

    OK thanks, I see how it works now. I must have inadvertently deleted the generated query somehow, so it looks like I'll have to start over.

  5. #5
    3 Star Lounger
    Join Date
    Dec 2001
    Location
    Schenectady, New York, USA
    Posts
    273
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Restore form (Access 2000)

    You can just create a query if you lost the old one.

    Create a new query
    Select the two tables you want.
    Join them on a common id (if not already connected, click the comon id on one table and drag to the other and drop it.)
    Select the fields you want
    Save your query.
    Open your form in design mode
    go to the Record source of the Form and follow Hans response to select your new query.
    Don
    <img src=/S/flags/USA.gif border=0 alt=USA width=30 height=18> <img src=/S/flags/NewYork.gif border=0 alt=NewYork width=30 height=18> "Life on Earth is expensive, but at least it includes a free trip around the Sun."

  6. #6
    5 Star Lounger
    Join Date
    Feb 2001
    Location
    Australia
    Posts
    676
    Thanks
    28
    Thanked 2 Times in 2 Posts

    Re: Restore form (Access 2000)

    OK, thanks for your replies. I know my way around Word and Excel but am just starting with Access, and your prompt and concise assistance is much appreciated.

Posting Permissions

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