I'm stuck!

[Marfun]

I am creating a database in Microsoft Access '97. My question is: how can I validate one field in a table/form with the data from another field? For instance, first I have a Yes/No field which is followed by a text field. What I want to do is that if in the first field No is chosen, then the second field becomes such that you are not allowed to enter data into it, or even if you do enter data into it, an error message comes up stating that no data should be entered into this field since you have chosen No. On the other hand, if you chose Yes in the first field, you can freely type into the second field without any error message coming up. How may I program my database so as to achieve this?

Any suggestions will be greatly appreciated.

Thanks fellow Access users, Marfun

 

[Atomic Shrimp]

Isn't this the same as your question 'Data Validation' in the VBA section??

(I've answered it there)

 

[Marfun]

Yes, the question is the same. However, I went to the VBA forum, and there were no replies to my 'Data Validation' question. How come?

 

[Atomic Shrimp]

Hmmm...

Maybe you need to click the 'refresh' button on your browser?