Results 1 to 3 of 3
  1. #1
    jcc285 is offline Advanced Beginner
    Windows 10 Access 2016
    Join Date
    Aug 2014
    Posts
    70

    Requery a subform following restore from task bar

    I am working on a project which generates a random set of CD tracks for a local charity radio station.
    The tracks are stored in a table. - New Tracks
    I have a form which displays, in a sub form, the randomly selected tracks in 'New Tracks' to the user.
    On the Main form I have a button which allows the manual addition of a track to the list from an All Tracks form.
    The sequence is:-
    1. Display the selected random tracks


    2. Click Add Track button
    3. Minimize the open form to the taskbar
    4. Open the All Tracks Form
    5. Select a track to add
    6. Click 'Add Track to List' button
    7. Write the selected track to table New Tracks
    8. Close the All Tracks Form
    9. Restore the original form from the taskbar

    My question is, how can I force the subform to perform a Requery on return from the taskbar ?

    I have tried Requery code in the Resize, Current, Data Change events among others with no success.
    In desperation I added an 'Update List' button to the Main Form but that is an annoyance and I think there must be a way to do this in the background.

    Any help gratefully received

  2. #2
    Ajax is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    8,232
    how about using the close event of the all tracks form to requery the main form or it's subform?

  3. #3
    jcc285 is offline Advanced Beginner
    Windows 10 Access 2016
    Join Date
    Aug 2014
    Posts
    70
    Quote Originally Posted by Ajax View Post
    how about using the close event of the all tracks form to requery the main form or it's subform?
    Yes, of course, thank you, sometimes you can look at something for toooo long!!
    Just needed to construct the path to the subform i.e.

    Forms!frm_New_Programme!frm_New_Programme_Subform. Form.Requery

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

Similar Threads

  1. requery 1 subform after activity on another subform
    By markjkubicki in forum Programming
    Replies: 5
    Last Post: 10-24-2019, 03:29 PM
  2. Restore changed data in subform
    By joecamel9166 in forum Forms
    Replies: 2
    Last Post: 07-01-2016, 11:30 AM
  3. Replies: 2
    Last Post: 06-24-2016, 05:46 PM
  4. requery subform
    By nswhit in forum Forms
    Replies: 2
    Last Post: 05-16-2013, 09:34 AM
  5. Replies: 3
    Last Post: 04-17-2012, 10:28 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 - Senior Forums