J
jseger22
Hi,
I have a form with a multiselect listbox(List17) and I have a query
qry_Projects_ListBox that contains the selections from this listbox.
I have a subform (sbfrm_Projects_ListBox) that contains text fields
from qry_Projects_ListBox. I placed the subform on my main form and
what is supposed to happen is when the user selects options from the
listbox, I use a command button to requery qry_Projects_ListBox so the
items will populate on the subform, but when I do this the subform
does not update, but if I open the subform separately the records are
there. My code to requery looks like. I am not sure what I need to
do here, thanks.
Private Sub Command109_Click()
Me.sbfrm_Projects_ListBox.Requery
End Sub
I have a form with a multiselect listbox(List17) and I have a query
qry_Projects_ListBox that contains the selections from this listbox.
I have a subform (sbfrm_Projects_ListBox) that contains text fields
from qry_Projects_ListBox. I placed the subform on my main form and
what is supposed to happen is when the user selects options from the
listbox, I use a command button to requery qry_Projects_ListBox so the
items will populate on the subform, but when I do this the subform
does not update, but if I open the subform separately the records are
there. My code to requery looks like. I am not sure what I need to
do here, thanks.
Private Sub Command109_Click()
Me.sbfrm_Projects_ListBox.Requery
End Sub