D
Dave Worthy
I'm calling procedures in the main form from events in
the subform (ie:currentform & updates of fields), that
will assemble the rowsource for the list boxes so that
they will reflect the proper info for each record .
I've done this with a number of systems and seems to have
worked fine. With the current system it works sometimes
and not others. I have 3 list boxes Reflecting 3
different views of the same inventory table. All three
worked fine on an orders form, but for a simpler version
of the same form, it worked briefly and now doesn't. One
list box is ok, the other two show no data, but the boxes
have been populated (listcount shows proper #). One will
come to life when I play with the vertical scroll bar.
Another problem is that if I use listbox.requery the
subform goes into a loop until stack space is exhausted.
I've spent days trying everything I can think of
including a couple of rebuilds, to no avail. Sometimes
works briefly but not stable enough to continue with
design.
Hopefully someone can offer assistance.
the subform (ie:currentform & updates of fields), that
will assemble the rowsource for the list boxes so that
they will reflect the proper info for each record .
I've done this with a number of systems and seems to have
worked fine. With the current system it works sometimes
and not others. I have 3 list boxes Reflecting 3
different views of the same inventory table. All three
worked fine on an orders form, but for a simpler version
of the same form, it worked briefly and now doesn't. One
list box is ok, the other two show no data, but the boxes
have been populated (listcount shows proper #). One will
come to life when I play with the vertical scroll bar.
Another problem is that if I use listbox.requery the
subform goes into a loop until stack space is exhausted.
I've spent days trying everything I can think of
including a couple of rebuilds, to no avail. Sometimes
works briefly but not stable enough to continue with
design.
Hopefully someone can offer assistance.