Hide in List box if field is No

[jeremy0028]

Hi I have the following in a list box called list0 on a form called
frmInsuranceSearch. Toward the bottom you will see a field called
qryInsuranceSearch.Active which contains a yes or no value. If yes
will show in list box if no will hide in the listbox.

SELECT qryInsuranceSearch.InsuranceName,
qryInsuranceSearch.InsuranceAddress1,
qryInsuranceSearch.InsuranceAddress2,
qryInsuranceSearch.InsuranceCity, qryInsuranceSearch.InsuranceState,
qryInsuranceSearch.InsuranceZip, qryInsuranceSearch.Active
FROM qryInsuranceSearch
ORDER BY qryInsuranceSearch.InsuranceName;


Any ideas.


Thanks in advance.

 

[Jeff Boyce]

WHERE Active = True

(I'm assuming you only want to see those for which the field is Yes/True...)

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/