Listbox value to query parameter

[steve1040]

Hi All,
Please forgive me I'm new to Access VBA
I'm attempting to make changes to an access database.



Currently I have a query that prompts for 3 values
Entity
Unit
WorkerType

I've created a form that allows the user to select each (Entity, Unit, WorkerType).

How do I pass the values from the 3 listbox to the query here is the query

 
PARAMETERS [Entity Name] Text ( 255 ), [Unit] Text ( 255 ), [Worker Type] Text ( 255 );
TRANSFORM Max(WorkertypeOnUnitISO.Expr1002) AS MaxOfExpr1002
SELECT WorkertypeOnUnitISO.fldEntity, WorkertypeOnUnitISO.WorkerType, WorkertypeOnUnitISO.fldUnit, Max(WorkertypeOnUnitISO.Expr1002) AS [Total Of Expr1002]
FROM WorkertypeOnUnitISO
WHERE (((WorkertypeOnUnitISO.fldUnit)=[Unit]) And ((WorkertypeOnUnitISO.fldEntity)=[Entity Name]) And ((WorkertypeOnUnitISO.WorkerType)=[Worker Type]))
GROUP BY WorkertypeOnUnitISO.fldEntity, WorkertypeOnUnitISO.WorkerType, WorkertypeOnUnitISO.fldUnit
PIVOT WorkertypeOnUnitISO.Quarter In ("1st Qtr","2nd Qtr","3rd Qtr","4th Qtr");

Thanks
Steve

[aytee111]

You are asking the user to enter the values twice. Instead, refer to the values on the form in the query:
WorkertypeOnUnitISO.fldUnit=Forms!formname!textbox nameforUnit
etc