Howto: User can only press Submit Query after entering all informa

[Lidschi]

Hi Newsgroup,

I have the following problem.
My users select their names from a dropdown list in the query section of a
SQL Server driven Infopath form. Then he needs to enter his password. Then he
can click on Submit Query. Problem is that the user can press on Submit Query
before entering his password. I can't make the SQL Server field a required
field in Infopath: Why is this so? Can I change it?

Thanks in advance for your help.

Regards
Lidschi.

 

[Ben]

if i understand your issue (and i am by no means an expert) you could add a
rule to the submit query button that checks the value of the password field
and if it's blank then it stops process rules.

alternatively/additionally, you could place the button in a section and have
that section hidden until a value is entered in the password field. this
wouldn't stop the user from going back and erasing the password and still
submitting with it blank.

or you could add a data field to capture the password, set validation on
that field and then have your sql server field pull the password from the
date field.

 

[Lidschi]

Hi Ben,

how can I hide a section?

Is there really no option to make a field required if it comes from SQL
Server?

Regards
Lidschi.

 

[Ben]

You can use conditional formatting on the section. Section
Properties|Display|Conditional formatting. Then you can set up condition to
hide the section as long as the control is blank.

I am no expert so there may be a way.

My assumption is your control is linked to a field in your sql table. if so
you should be able to open properties on the control and set data validation
on the contol.