Results 1 to 2 of 2
  1. #1
    jasabel is offline Novice
    Windows 7 Access 2007
    Join Date
    Jul 2010
    Posts
    10

    How to refresh field list in a query based on a table/query that has changed ?

    I have a query (2) base on another query (1) using Access Query Designer.


    If I add some field to the query (1) when I tried to modify the query (2) it shows the old list of fields. This is to say, it does not refresh my changes on the query 1.
    This really drives me crazy.
    How do you do that whithout deleting and adding the table again.
    Thanks again

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    you cant have Q2 open when you change Q1.
    once you change Q1, then you can open Q2 and the changes will show.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 8
    Last Post: 07-13-2015, 12:51 PM
  2. Replies: 3
    Last Post: 06-25-2015, 01:27 PM
  3. Replies: 1
    Last Post: 12-02-2014, 09:26 AM
  4. Replies: 1
    Last Post: 10-22-2014, 12:44 PM
  5. Replies: 9
    Last Post: 05-13-2014, 08:22 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums