this properties or method is not supported by this object

[Lightlancer]

Hi there,

In my table "tblstatus" i have a field named "Versie" its a Text field.

in that field this number is filled in: 211880

In my first form of the database, a field (that is hided) has also a number: "211880"

the form must look if this number is the same, higher or lower....

If DLookup("[Versie]", "[tblstatus]") >= [Me.Versie] Then
        MsgBox "Er is op dit moment een update van de database. Indien u weet hoe u moet updaten, installeer dan zo snel mogelijk de nieuwe versie. indien u niet weet hoe dit werkt, bel dan 6667", vbOKOnly, "Update vereist!"
        Cancel = True
        DoCmd.CloseDatabase

it seems to give an error at

If DLookup("[Versie]", "[tblstatus]") >= [Me.Versie] Then

am i doing something wrong??

p.s. I tried to create a new table in de forms database, with this number also as text. but it gives the same error:

"this properties or method is not supported by this object"

Greetz

Lightlancer

 

[Lightlancer]

Solved it, by changing Me.Versie to

DLookup("versie", "versie")

 

[MajP]

That is a band-aid. The real solution is
me.Versie

This of throws an error
[Me.Versie]

It would be like
X = [y]
or x = ["Some String"]

You have brackets around an object which is improper notation.

 

[Lightlancer]

thanks for the tip