Report.

  • Thread starter Thread starter Sigh
  • Start date Start date
S

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.
 
Sigh said:
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.
Click to expand...
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?
 
-----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.
.
Click to expand...
Looks like a syntax error, try:
Docmd.OpenReport "ReportName",,,"[ID] = " & Forms!
[frmMain]![listBox].value
 
Back
Top