I would like to allow my users to first select which company they would like to process reports for. The selection is a combo box, dropdown. Based off the company, I would like for my users to select from a list only those personnel within that company who they want to runreports for. Can anyone assist?
Thanks in Advance.


1. If the personel for all firms are in one table:
Put the RowSourceType of the ListBox = 3 && SQL Statements
In InterActiveChange Event of the combo Put this:

thisform.ListBox1.RowSource = "SELECT * FROM YourPersonelTable WHERE YourPersonelTable.FirmId = '"+this.Value+"' INTO CURSOR cPersonel"
thisform.ListBox1.Requery()

Keep in mind that if the FirmID is Numeric Value You must remove single quote before & after this.Value & use STR(this.Value) instead



2. If the Personel are in Different tables, Put the
Put the RowSourceType of the ListBox = 6 && Fields
In InterActiveChange Event of the combo Put this:

DO CASE
   CASE this.Value == FirrsFirmID
        thisform.ListBox1.RowSource = "TableOfPersonelForFirstFime.FieldYouHaveToDisplay"
.......
ENDCASE
thisform.ListBox1.Requery()