Limit data input

[Richard C]

I want to stop is false data being entered into my
database. One problem I have is that you can input a start
date, then you could enter an end date that would be in
the past.

e.g.
6th September 2004 = Start date
1st September 2004 = End date

I thought of using this expression

EndDate >= StartDate

Where would I have to enter that expression for it to stop
users entering false data? I went to the table design view
for the data entry and on the EndDate field I placed that
expression in the validation rule, which didnt work. I
then did the same to Input mask and still no luck.

Any ideas anyone?

Rich

 

[Joan Wild]

You need to put the validation property in the table, not the EndDate field.

In design, go to View Properties, and you'll see the properties window for
the table. You can set the validation rule there.