run a requery button upon returning to a form.

[deejay_totoro]

Hello all,

I have a question based on what I learnt in:

http://www.access-programmers.co.uk/forums/showthread.php?t=56823

My main form contains a control that gets its date from the calendar. This date is then passed to the form's underlying query.

In order to requery the form (and display the data according to the date selected) I have a requery button.

What I can't seem to be able to figure out is: how to get the main form to automatically trigger the requery button when I return from the calendar form?

Any ideas?

Many thanks!

dj_T

 

[WayneRyan]

dj_T,

The calander form can:

Forms![YourMainForm].Requery

Wayne