How to modify code to open report instead of form

[kassem]

Hi guys,

the following code opens a form to the specific record clicked on the listbox. This works but i want the code to open a report instead. I tried changing OpenForm to OpenReport and FormName to ReportName but it keeps printing the report instead of opening it, thanks.

DoCmd.OpenForm FormName:="Trouble_Report", _
       WhereCondition:="[Device ID]='" & Me.
[List311] & "'"

[Subwind]

Hi guys,

the following code opens a form to the specific record clicked on the listbox. This works but i want the code to open a report instead. I tried changing OpenForm to OpenReport and FormName to ReportName but it keeps printing the report instead of opening it, thanks.

DoCmd.OpenForm FormName:="Trouble_Report", _
       WhereCondition:="[Device ID]='" & Me.
[List311] & "'"

DoCmd.OpenReport "Trouble_Report", acViewPreview to preview
DoCmd.OpenReport "Trouble_Report", acViewPrint to print

[kassem]

I tried

DoCmd.OpenReport "Trouble_Report", acViewPreview 
       WhereCondition:="[Device ID]='" & Me.

[List311] & "'"

but its saying the where condition now has incorrect syntax do you know why?

[Subwind]

I tried

DoCmd.OpenReport "Trouble_Report", acViewPreview 
       WhereCondition:="[Device ID]='" & Me.

[List311] & "'"

but its saying the where condition now has incorrect syntax do you know why?

All my reports are based on queries that filter the data for me so I am unable to help on that front.

~Matt

[Missinglinq]

Your syntax of

"[Device ID]='" & Me.[List311] & "'"

is only correct if [Device ID] is defined as a Text Field. If it is defined as an actual Number, then correct syntax would be

"[Device ID]= " & Me.[List311]

Linq ;0)>