Is this a macro, validation or field condition question

[jburgess1974]

Not sure what forum this needs to be placed.

I have a database that has a number of fields. My question is this. I am wanting the most simplest way currently.



One field is a status field. The status codes are there is a pending code and rest are closed cases. Then there is another field that is a date field. I have a macro setup that is an information dialog box.

What I am wanting to do is if a status code is pending then database will not allow date field to be filled and the macro dialog box pops up.

[ranman256]

In your form,
set the txtDate.enabled = false.

when the user changes the status code, status.AFTERUPDATE event....
set the txtDate.enabled to true.
Also the form ON CURRENT event...
txtDate.enabled = status = "closed"