[AccessD] problem with DoCmd.OpenReport

Hello Stuart and others,

Sorry i mistyped in that mail.
In my code the report (stDocName) is there, like in your line of code you
mentioned.
Sorry for this.
When i use the code i get the Syntax error(operator missing)?????

Pedro



Private Sub cmdDymoEtiket_Click()

Dim stDocName as String
Dim strExp as string

strExp = "[code] =" & Me![Code]
stDocName = "EtiketqryDymo"
DoCmd.OpenReport stDocName, acViewPreview, , strExp

End sub







----- Original Message -----
From: "Stuart McLachlan" <stuart at lexacorp.com.pg>
To: "Access Developers discussion and problem solving"
<accessd at databaseadvisors.com>
Sent: Thursday, February 05, 2004 10:58 PM
Subject: Re: [AccessD] problem with DoCmd.OpenReport


> On 5 Feb 2004 at 22:46, Pedro Janssen wrote:
>
> > strExp = "[code] =" & Me![Code]
> > stDocName = "EtiketqryDymo"
> > DoCmd.OpenReport, acViewPreview, , strExp
> >
> > End sub
> >
> > When i use this i get an error:
> > Syntax error (operator missing).
> >
> > How is this possible, i used this code many times before with forms.
> >
>
> You forgot to tell it which report to open <g> :
>
> DoCmd.OpenReport stDocName, acViewPreview, , strExp
> --
> Lexacorp Ltd
> http://www.lexacorp.com.pg
> Information Technology Consultancy, Software Development,System Support.
>
>
>
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
>