Error with VBA code 1

[Superguppie]

Hi all,

i have the following problem. when i add this code to VBA:

docmd.OpenForm(frmOplossing,,,="[Ticketnummer]=" & [Ticketnummer],,acDialog)

VBA will give the following Error (hope i did translate it well???)

Expecting expression

What is wrong about this code??

Greetz
Superguppie

 

[TheAceMan1]

How are ya Superguppie . . .

Remove the 1st [blue]=[/blue] . . .

See Ya! . . . . . .

Be sure to see thread181-473997
Also faq181-2886

 

[Superguppie]

i should have known....... lol

well thanks again

 

[Superguppie]

mmmm, still not good,
now VBA tells me:

Expecting =

 

[TheAceMan1]

Superguppie . . .

DoCmd.OpenForm is a [blue]Method[/blue] not a function! Remove parenthese [blue]()[/blue]

See Ya! . . . . . .

Be sure to see thread181-473997
Also faq181-2886

 

[Superguppie]

ok, when i type docmd.openform it gives me automaticly an example how to use the Method, and in the example there was () but i know it now

Thanks for the info its solved now

 

[TheAceMan1]

Superguppie . . .

Your seeing whats called [blue]Auto List Members[/blue] (arguement definitions as a hint of what to do) and is not an explicit syntactical representation. For the actual syntax, always view it in help (put the cursor on a keyword like [blue]OpenForm[/blue] and hit [blue]F1[/blue]

See Ya! . . . . . .

Be sure to see thread181-473997
Also faq181-2886