I have a form with a combo box that displays active firms. When a firm is marked inactive, it should disappear from the combo box, but not from the record in the form. I checked the table that stores this data and the inactive firm is in the record, but it just doesn't show on the form.
Below is the code for the combo box.
Code:
SELECT dbo_IA_FIRM.IA_FIRM_ID, dbo_IA_FIRM.IA_FIRM_NAME
FROM dbo_IA_FIRM
WHERE (((dbo_IA_FIRM.INACTIVE)=False))
ORDER BY dbo_IA_FIRM.IA_FIRM_NAME;
Thank you for your help.