List box

[rich001]

I am trying to refine this query with a list box to select the appropiate result. the form is [emplist] and the box is [choosen](table it sends data to is tblChoose) What is the easiest way to do this filtering the fields StatusA, B, and C?

****NOTE: I DID NOT CREATE THIS MESS I AM JUST TRYING TO FIX IT!!!!!****

PARAMETERS [Forms]![emplist]![EnterStartDate] DateTime, [Forms]![emplist]![EnterFinishDate] DateTime;
SELECT DISTINCTROW [SALES STATUS].Ss_WO_NO, [SALES STATUS].[Ss_DATE_REC'D], [DESPATCH STATUS].Ds_Instance, [SALES STATUS].[Ss_DATE_REC'D], [SALES STATUS].Ss_QUOTE_NO, [SALES STATUS].Ss_CUSTOMER_NAME, [SALES STATUS].Ss_CODE, [SALES STATUS].Ss_CUST_ORD_NO, [SALES STATUS].[Ss_PART_NO/DRWG], [SALES STATUS].Ss_ISSUE_NO, [SALES STATUS].Ss_QTY, [SALES STATUS].Ss_PRICE_PER_100, [DESPATCH STATUS].[Ds_DATE_Ship_Req'd], [DESPATCH STATUS].Ds_WK_ACK, [DESPATCH STATUS].[Ds_QTY_REQ'D], [DESPATCH STATUS].[Ds_DATE_REQ'D], [DESPATCH STATUS].[Ds_WK_REQ'D], [DESPATCH STATUS].Ds_DESPATCH_QTY, [DESPATCH STATUS].Ds_DESPATCH_DATE, [Ds_despatch_qty]*[Ss_PRICE_PER_100]/100 AS Expr1, [DESPATCH STATUS].Ds_DATE_ACK, [DESPATCH STATUS].Ds_Ship_Comment, [DESPATCH STATUS].StatusA, [DESPATCH STATUS].StatusB, [DESPATCH STATUS].StatusC, [DESPATCH STATUS].MachineCodeA, [DESPATCH STATUS].MachineCodeB, [DESPATCH STATUS].MachineCodeC
FROM [SALES STATUS] INNER JOIN [DESPATCH STATUS] ON [SALES STATUS].Ss_WO_NO = [DESPATCH STATUS].Ds_WO_NO
WHERE ((([DESPATCH STATUS].[Ds_DATE_Ship_Req'd]) Between [Forms]![emplist]![EnterStartDate] And [Forms]![emplist]![EnterFinishDate]));