Refresh

  • Thread starter Thread starter el zorro
  • Start date Start date
E

el zorro

I have Form A with a list box. From Form a user can click
on a button and open Form B and add items to the list
box. If I requery the list box on FOrm A via the On Close
event of FOrm B, the list refreshes. But I want to also
use FOrm B as a stand-alone form, and don't want an error
message every time I close it (because the program is
looking for the list to requery on FOrm A, which is not
open).

Sooo.. I'm looking for a way to get the list to refresh
by some action that happens on Form A. Basically, I want
the form to refresh without the user having to go to the
Menu and select "Refresh." I've tried
using "List.requery" on an event procedure for On
Activate, On Current, On Got Focus... nada. I still have
to go to the Menu to refresh the list (i.e., add the new
information to tjhe list). I must be doing something
wrong... any thoughts?
 
try this code in the OnClose event in Form B:

If CurrentProject.AllForms("FormA").IsLoaded Then
Forms!FormA.Requery
End If

hth
 
Back
Top