[AccessD] problem with DoCmd.OpenReport

Hello Stuart,

the messagebox gave me the right value of field Code.
Then trying again. Same Error.
Then i switched field [code] in the [ID] field of the table.
Voila everything worked fine.
Strange, because the code field is also an Unique ID field.

Thanks fot your help.

Pedro Janssen



----- Original Message -----
From: "Stuart McLachlan" <stuart at lexacorp.com.pg>
To: "Access Developers discussion and problem solving"
<accessd at databaseadvisors.com>
Sent: Friday, February 06, 2004 12:49 AM
Subject: Re: [AccessD] problem with DoCmd.OpenReport


> On 6 Feb 2004 at 0:03, Pedro Janssen wrote:
>
> > 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)?????
> >
>
>
> Try putting a Msgbox "Test" at the start of the report's On_Open to see
> where the problem really is. If you get the message box before the error,
> then it's something in the report or underlying query that's causing it.
>
>
>
>
>
> --
> Stuart McLachlan
> Lexacorp Ltd
> Application Development,  IT Consultancy
> http://www.lexacorp.com.pg
>
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>