Query based on Combobox Value

[Stretch2312]

HELP. I cannot get my query to recognize the value in my combo box. It keeps asking me to enter it manually.

I have never posted here before (or any where for that matter) so please let me know what more info you require


Regards

[Bob Fitz]

Can you show us the query's SQL statement

[Stretch2312]

SELECT FLOC.ID, FLOC.FLOC, FLOC.Assembly, [Forms]![Tags]![comboline] AS Expr1, [Forms]![Tags]![cboMachine] AS Expr2
FROM MACHINE INNER JOIN (LINE INNER JOIN FLOC ON LINE.LineID = FLOC.Line) ON MACHINE.MachineID = FLOC.Machine
ORDER BY [Forms]![Tags]![comboline];

[orange]

You may want to read/work through some of these tutorials
http://www.techonthenet.com/access/comboboxes/