Validation Rule....Pls help.....Thanks

[raeleong]

Hi.....

I have 2 fields, 'Status' and 'Date'
'Status' is a combo box which contain 4 datas.
I need to validate the 'Date' field.
Allow update 'Date' data where the data of 'Status' field is = DONE

Pls help how to create the validation rule on the 'Date' field.

Thank

 

[John Vinson]

Hi.....

I have 2 fields, 'Status' and 'Date'
'Status' is a combo box which contain 4 datas.

No, it isn't.

Tables do not contain combo boxes. They contain DATA. A combo box is a
tool to *display* data.

I need to validate the 'Date' field.
Allow update 'Date' data where the data of 'Status' field is = DONE

Pls help how to create the validation rule on the 'Date' field.

A field validation rule cannot refer to another field in the table -
and it's not clear just what validation rule you want! If you want to
control whether or not the Date field can be updated, a validation
rule will not help you - all it can do is constrain what values you're
allowed to update it TO.

Could you explain the business problem you're trying to solve?