date = date doesnt work in macro

[Lightlancer]

Hi there,

im trying to open another form with a Where condition,

"=[Datum=]" & "[Datum]"

but instead i get a syntaxis error, somethign like that, Dutch hard to translate..........

am i doing something wrong , the samecode works for another form but that isnt a date......

I hope someone can help me with this...

Greetz,

Lightlancer

 

[JBinQLD]

Datum=" & Date() ?

JB

 

[Lightlancer]

no that isnt right,

the form that opens will show the date of present,
it must show the date that was shown in the form before

 

[JBinQLD]

tell me, does a record already exist with that date or are you wanting to open the form at a new record and set thet date as a default?

 

[fneily]

=[Datum=]" & "[Datum]" - syntax errors.
"[Datum] = " & Forms![TheFormName]![Datum]

 

[Lightlancer]

i solved it to add a MessageID to the table and the form, and with the same code its works now,....
problem solved

 

[JBinQLD]

good work, well done

 

[missinglinq]

I'm glad you got a workaround. When using dates like this you usually need to tell Access that they're dates by using the #delimit symbol.

"[Datum]= " & "#" & [Datum] & "#")

The Missinglinq

Richmond, Virginia

There's ALWAYS more than one way to skin a cat!

 

[Lightlancer]

Thanks for the tip, next time i will use this......