I have a list box [lstDeptEquip]. I also have an unbound field [txtAmount]. I want the list box to update with the cost to be equal to or greater than the number [txtAmount]. I used this statement in the list box: SELECT [EquipID], [UTIDNumber], [SerialNumber], [EquipDesc], [EquipCost], [CurrentLoc] FROM qryEquipmentInv WHERE OutOfInv = False and EquipTypeID <> 22 and EquipTypeID <> 23 and EquipTypeID <> 24 and CategoryID <> 2 and DeptOwned and Not(Not Isnull(ReturnedDate) and Issued) and [EquipCost] >= Val(Forms!frmEquipDeptInv!txtAmount) ORDER BY [UTIDNumber];
It is ignoring the [EquipCost] >= Val(Forms!frmEquipDeptInv!txtAmount) completely. I’m not sure what I’m doing wrong.