Thanks for the quick reply. However I'm not understanding either of the
replies. I think I understand what your saying althoug I'm not sure how to
enter or write what you are telling me. Also now that I have read your
replies and re-read my question I think I need to add more detail, which I
probably should have done in the first place.
This part of my database has three objects(?).
Tables:
Red Tag DC
Resolution
Form:
Red Tag DC Form
In the form is also a field (Combo Box) called "Resolution". The Resolution
field (combo box) has several options, one of those options is "Use As Is".
Also in the form is a field (Text Box) called TDA#.
Both of these fields are "not required".
If someone enters "Use As Is" into the Resolution field (combo box) I'd like
to have the TDA# field become "required".
Is this possible? Is it still as you have replied to me originally? If so
could you give me some more help in entering the information necessary to
make it happen? If it requires other code would you please provide the
detail?
If it can't happen at all thanks for your interest and I apologize for
wasting your time in the first place.
I'll explain why I'd like this. The only way product can, or should, be
used when designated as "Use As Is" is with a TDA. So making this field
"required" when someone enters "Use As Is" would ensure that this
information is recorded.
I hope I've explained this better and once again I apologize for not doing
this in the first place.
"Don Sealer" <vz******@verizon.net> wrote in message
news:daXWe.2232$e_4.1723@trndny08...
I've got a validation rule that says something like =xx or xxx or
zzzz. Though I may not have described it well it does work fine and that is
really not my question.
Here's what I'd like to do. Let's say that I choose zzzz, I'd like
for a particular control (or text box) in my form to become required. At
other times, if xx or xxx is inputed it would not be required. Is this
possible?
Thanks, and as always, further explanatiions will be forthcoming,
Don..........