Data Validation Problem

M

Misfit

I have be struggling with some of the simplest things lately and have
having searching and finding nothing I thought I would try posting in
these forums for help. I have a text box that I want to make required
dependent upon a drop-down list.

This works: [textbox] is blank and [drop-down list] does not contain
"something"
This insures that my textbox is not blank but will allow it to
be blank if the drop-down list contains "something"


This does not work: [textbox] is blank and [drop-down list] does not
contain "something" or [same drop-down list] does not contain
"something else"

Ultimately what I would like to have is that my textbox is required
unless the drop-down list contains "something" or "something else"
 
C

Clay Fox

Are you doing this in data validation?

If textbox = blank and dropdown = something works
does textbox = blank and dropdown = somethingelse work?
If both of these work then it is probably just a matter of your or structure

In this case you would want textbox=blank and dropdown = something OR
text=blank and dropdown=somethingelse

--
Thanks

Clay Fox

Qdabra Software
http://www.qdabra.com

InfoPathDev.Com
The Largest InfoPath Forum in the World
http://www.infopathdev.com
 
M

Misfit

I was so hoping that would work but I'm still having the same problem
as before. I can choose "something" or "something else" and its
still a required field.
 
C

Clay Fox

You would want not equal on the something or something else it sounds like.
You want the field required if it is blank and the drop down equals something
or somethingelse.

You could also use some message boxes with rules with the same logic. This
sometimes helps to debug. Maybe on your dropdown so that when it is switched
to something or somethingelse you know your condition statement is being met.
--
Thanks

Clay Fox

Qdabra Software
http://www.qdabra.com

InfoPathDev.Com
The Largest InfoPath Forum in the World
http://www.infopathdev.com
 
M

Misfit

This is what I currently have in place and this works fine

[textbox] is blank and [drop-down list] does not contain "something"

its just that I want to having more then one something :)
It seems to me that this shouldn't be that complicated and maybe my
form is bugged in someway and I should start over...

As far as the message boxes and with rules and the same logic go I
would love to but at this very moment I have a limited understanding
of the api for infopath. Ive just recently ordered a book that I hope
will help me but it hasn't come in yet.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top