I have a form that is based on a query from a larger table. It displays Chairpersons and their contact information. I would really like to have a listbox control on the form that displays the other staff associated with that organization and their titles. I have gotten the listbox to display them in the right order, but there is no truncation (separation) when the associated staff ends, instead, it is a continuous list.
This listbox is populated with a query that is related to the original query for the form.
Is there anyway to do this, or do I have to resort to a subform?
This listbox is populated with a query that is related to the original query for the form.
Is there anyway to do this, or do I have to resort to a subform?
