Refresh/Requery Listbox from subForm

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a subform that I use to delete records that are not needed (usually
duplicates). Deleting the record is no problem, but once the record is
gone, the reference is still in the non-refreshed listbox. How do use VB to
refresh the listbox?

Form: IssEditNew/lstInISS
Subform: subISSEditMain
 
In
Ripper said:
I have a subform that I use to delete records that are not needed
(usually duplicates). Deleting the record is no problem, but once
the record is gone, the reference is still in the non-refreshed
listbox. How do use VB to refresh the listbox?

Form: IssEditNew/lstInISS
Subform: subISSEditMain
Click to expand...

If the list box is on the main form, but you need the code to requery to
run on the subform, then use and expression like this:

Me.Parent!YourListBoxName.Requery
 
Back
Top