Hello Tony,
I would then recommend adding an Initial Value to your field. Let's say below is your combo box's selections:
1.) Text = -- Select One -- Value = -1
2.) Text = Yes Value = Yes
3.) No = No Value = No
#1 should be defaulted.
I would then create a SQL Validation to prevent the first selection from being submitted. The SQL Validation will act as a Required Validation as well as preventing the initial selection from being submitted.
The SQL Validation could look like this:
---------------------------------------------------------------------------------------------------
IF '$(CombBox_ShortFieldName)' = '-1'
BEGIN
Select 'False' As IsValid
END
ELSE
BEGIN
Select 'True' As IsValid
END
---------------------------------------------------------------------------------------------------
Please review our Dynamic Forms User Guide to learn more about the SQL Validation feature:
http://www.datasprings.com/userguid...rGuide.pdf Pages 124 & 125
-Ryan