form run report

[eugz]

Hi All.
I created simple form with combobox to select device and button that run report. Report Record source is:

SELECT Request_id, Date, Device, Request, Amount 
FROM qRequest 
WHERE (Device=Forms!fSetRequestRpt!cboDevice) 
ORDER BY Date;

When I select device in combobox and click button to run report my report is empty. What is my wrong?
Thanks.

 

[Moniker]

"SELECT Request_id, Date, Device, Request, Amount
FROM qRequest
WHERE (Device='" & Forms!fSetRequestRpt.cboDevice & "')
ORDER BY Date;"

 

[Rich]

Date is a reserved word in Access and should not be used as a field name