Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / General MS InfoPath Questions / October 2007

Tip: Looking for answers? Try searching our database.

Data Validation Problem

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Misfit - 04 Oct 2007 12:49 GMT
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"
Clay Fox - 04 Oct 2007 13:25 GMT
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

Signature

Thanks

Clay Fox

Qdabra Software
http://www.qdabra.com

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

> 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
[quoted text clipped - 12 lines]
> Ultimately what I would like to have is  that my textbox is required
> unless the  drop-down list contains "something" or "something else"
Misfit - 04 Oct 2007 14:16 GMT
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.
Misfit - 04 Oct 2007 14:40 GMT
I just wanted to be clear, I'm using InfoPath 2k3 not 2k7
Clay Fox - 04 Oct 2007 15:02 GMT
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.
Signature

Thanks

Clay Fox

Qdabra Software
http://www.qdabra.com

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

> 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.
Misfit - 04 Oct 2007 18:45 GMT
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.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.