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