InfoPath validating data before going through to Access database


I set up the following form in Infopath using the wizard to connect it to an Access database
How do I now add valudation to the fields? Should I have done it in the Access database first before creating the form?


Murray BrownMicrosoft Cloud Azure/Excel Solution DeveloperAsked:
Who is Participating?
livanescuConnect With a Mentor Commented:
the form is supposed to validate - and infopath does that very well
in design mode,
you can define what rules apply to each field (select Rules in 2010 or Data Validation in 2007)
the validation will define if one can submit to the database or not
you can also restrict the number of values for a field by replacing textboxes with dropdowns
etc etc
Clay FoxDirector of Business IntegrationCommented:
you must submit.

I believe you should already have the submit data connection, since it is in your main data schema, web services, SharePoint, email, etc you create manually.

Add a button that is a rules type and set the action to submit data.  Real straight forward.

You need to spend some time playing with it and getting a feel for it.
Clay FoxConnect With a Mentor Director of Business IntegrationCommented:
Not sure what I just read, its early.
Validation can be done a number of ways.

You can have rules and actions on each field that checks the value and notifies the user.  You can disable fields if previous fields are blank or not the right values.

Or you can check everything at the end when they submit.
Murray BrownMicrosoft Cloud Azure/Excel Solution DeveloperAuthor Commented:
Thanks very much
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.