Property field : Valid if

[habiler]

Hello every,

I would wish to know how to put a condition in the property field : valid if .

I have 2 fields date [begin] and [end].

I would that [end] cannot be lower or equal at [begin]. I tried

>= [begin]

but I receive a fault.

Thaks

Habiler

 

[arnelgp]

>=Nz([begin], 0)

 

[habiler]

It doesn't work.

Syntax error.

Thks

Habiler

 

[Solo712]

Hello every,

I would wish to know how to put a condition in the property field : valid if .

I have 2 fields date [begin] and [end].

I would that [end] cannot be lower or equal at [begin]. I tried

>= [begin]

but I receive a fault.

Thaks

Habiler

You cannot use "[end]" as a field name because it is an Access reserved word. Choose another name!

Best,
Jiri

 

[habiler]

in fact the field is named [fin] in french.

Kr

Habiler

 

[arnelgp]

if it doesnt work then use the form's control name.