Syntax Error

From: "CK" <CK@xxxxxxxxxxxxxxxxxxxxxxxxx>
Date: Wed, 27 Apr 2005 08:20:09 -0700

I have a form where a user can enter the date so that a list of invoices
meeting that date will be printed. My code looks like this:

Dim strWhere As String
strWhere = "'[dteInvoiceDate]=" & Me.txtSpecificDate '"
DoCmd.OpenReport "rptInvoiceListByDate", acPreview, , strWhere

However I get a Syntax error in string in expression. Is there something
wrong with the code? Thanks.
ck
.

Follow-Ups:
- Re: Syntax Error
  - From: Graham R Seach

Prev by Date: RE: DateAdd problem
Next by Date: RE: pass a calculated form field to a subform field?
Previous by thread: Incremental increasing a Fields numeric value
Next by thread: Re: Syntax Error
Index(es):
- Date
- Thread

Relevant Pages

Re: Multi options
... Dim strWhere As String ... MsgBox "Please enter a start and end date to run this report." ... Dim stDocName As String ... Dim strWhere As Integer ...
(microsoft.public.access.formscoding)
Re: Multi options
... Doug Steele, Microsoft Access MVP ... It's only reading in one String once I get this one under ... Dim stDocName As String ... Dim strWhere As String ...
(microsoft.public.access.formscoding)
Re: Multi options
... Dim stDocName As String ... Dim strWhere As String ... Doug Steele, Microsoft Access MVP ...
(microsoft.public.access.formscoding)
Re: Searching Through ComboBoxes
... Dim strWhere As String ... boxes are looking up, so you will have to use the real names. ... The name of the combobox is PARID. ...
(microsoft.public.access.formscoding)
Re: Multi options
... Dim strWhere As Integer ... MsgBox "Please enter a start and end date to run this report." ... Public stStart As String ... Dim stArea As Variant ...
(microsoft.public.access.formscoding)