SELECT LoanOff c_filt = "LoanOff.BrancField = '"+this.Value+"'" &&You must Transform the value if it is a numreic SET FILTER TO &c_filt thisform.SecondCombo.Requery()2) You can use put RowSourceType=3 SQL Statement for the second Combo & do something like this in InterActiveChange event of the first Combo:
thisform.SecondCombo.RowSource = "SELECT * FROM LoanOff WHERE LoanOff.BranchField = '"+this.Value+"' INTO CURSOR cLoan" thisform.SecondCombo.Requery()HTH