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

  • Thread starter Thread starter raeleong
  • Start date Start date
R

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
 
Hi.....

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

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.
Click to expand...

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?
 
Back
Top