I am a beginner at programming and having a bit (understatement) of
trouble with VBA.

I'm trying to open a report with a where clause that limits the report
to those records that have a certain date called [DateArchived]. The
variable that that I am trying to use in the WhereClause is a date
variable called Dte.

I have also tried the actual name of the control which is a combo box,
showing dates called [List3], double clicking on it then gives me the
value of Me![List3] = Dte

When I allow this Double-Click sub  to execute the report opens , but
with no records. My problematic line of code looks something like this,
although I've tried all manner of extra ' or " or #.

DoCmd.OpenReport "ReprintOrder", acViewPreview,, "Where [DateArchived]
=  " & Dte & ""  

If anyone can write this line for me, or tell me that I can't open a
report in this way then I may be able to get some sleep again in the
near future.  

not on my computer at the moment.

Thanks Paul Mendlesohn.

Clare,

 dim Dte as date
 Dte = cdate("1/15/1992")  'or whatever

docmd.openreport "rptYourReport", acViewPreview,, _
  "[DateArchived] >= #" & Dte & "#"

-- Jim Ferguson, FMS
   http://www.fmsinc.com

Clare,

Did you try:

DoCmd.OpenReport "ReprintOrder", acViewPreview,, "Where [DateArchived]

HIH,

Laura Wilson