"Requery"?

  • Thread starter Thread starter Ralph Wischnewski
  • Start date Start date
R

Ralph Wischnewski

I have a dispatch system that includes the functionality
to "Close Out" the calls from customers that caused the
dispatch.

The user that closes out the calls uses an unbound form
that applies a filter to find a specific call or typically
a group of calls that need to be closed. This form closes
and opens a form that shows the filtered records("Unclosed
Calls"). On selecting a specific record the "Close Out"
entry screen is opened for input of "closing" data.
The "Unclosed Calls" screen remains open so as to avoid
the user haveing to make the selection again. After
closing out the first call the user returns to
the "Unclosed Calls" screen to select the next call. This
form abviously still includes the first call which is no
longer an unclosed call.

I am having difficulty refreshing this screen without
having the user actually making the same selection again.
I suspect that a "requery" and /or "applyfilter" is
required but I can't seem to find when and where this
should occur - on closing the "Closing" screen, on
focusing or activation of the "Unclosed Call" screen? ....
nothing seems to work.

Any ideas?

Thank you
 
Try forms!formname!controlname.Requery

I suspect you would need to put this on the OnClose event
or the afterupdate event for the field you use to close
out the call of the Close Out form, but I am not certain.
Play with it. You might also try the OnCurrent event for
the Unclosed Call form.

I hope this helps!
 
Back
Top