Thanks for the reply, but is there a way to create a validation rule that
would specifically look for words. for example:

in the "Type of Document" column there are three options: "nursing report",
"progress note", incident report". Depending on what type of document is
selected, certain fields should be required to filled in.

If "nursing report" than "type of injury" must be filled in.
If "progress note" than "program" must be filled in.
If "incident report" than "Description of incident" must be filled in.

"Allen Browne" wrote:

Put a validation rule on the *table* (not field.)

2nd example under the the Validation Rules for Tables section he
http://allenbrowne.com/ValidationRule.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.


"CorpTrainer570" wrote in message
...
I am trying to create a database in which some of the fields should be
mandatory only under certain conditions.

For example:

In my "Type of Injury" column, I want the user to be required to enter a
value in this column, only if the value in the "Type of Document" column
is
"Nursing Report". Is this possible? I am only just beginning to teach
myself Access, so please bear with me. Thank you.

.