*** Set up the SQL statement to use as the RowSource for the personnel combo box *** Select only the items that have a CompanyID equal to the Item selected in the company combo box lcRowSource = 'SELECT EmployeeName, EmployeeID FROM Personnel ' lcRowSource = lcRowSource + 'WHERE Personnel.CompanyID = ( Thisform.cboCompany.Value ) INTO CURSOR csrPersonnel ' *** Now set up the combo box's properties WITH Thisform.cboPersonnel .BoundColumn = 2 .BoundTo = .T. .RowSourceType = 3 .RowSource = lcRowSource *** Don't forget to repopulate the control's internal list .Requery() *** Inialize it to display the first item .ListIndex = 1 ENDWITHThen, in the Valid() of the companies combo, you just requery() the personnel combo.