Report.

[Sigh]

I was wondering if there was any way that I could create a
report base on the items on the listbox of the form?

Here's my statment but is not working.

Docmd.OpenReport "ReportName",,,"[ID] = Forms![frmMain]!
[listBox].value

Any help would be very appreciated.

 

[fredg]

I was wondering if there was any way that I could create a
report base on the items on the listbox of the form?

Here's my statment but is not working.

Docmd.OpenReport "ReportName",,,"[ID] = Forms![frmMain]!
[listBox].value

Any help would be very appreciated.

It's probably a printer problem.
What happens if you format the trend line a bit heavier?
Or.. Change the Spooling settings?
Or.. Print directly to the printer?

 

[frank]

-----Original Message-----
I was wondering if there was any way that I could create a
report base on the items on the listbox of the form?

Here's my statment but is not working.

Docmd.OpenReport "ReportName",,,"[ID] = Forms![frmMain]!
[listBox].value

Any help would be very appreciated.
.

Looks like a syntax error, try:
Docmd.OpenReport "ReportName",,,"[ID] = " & Forms!
[frmMain]![listBox].value