Mandatory fields on the fly?

CodeCharge Studio

Web Reports

Visually create Web Reports in PHP, ASP, .NET, Java, Perl and ColdFusion.
CodeCharge.com

YesSoftware Forums -> CodeCharge Studio -> ASP

Mandatory fields on the fly?

Author

Message

cobom

Posts: 55

Posted: 09/23/2004, 6:27 PM

In many of our drop down selections for fields we have added an "Other" catagory. If that is selected then a Notes field should be filled out to explain why "Other" was selected - if this is not done then the report writer is left to guess why the standard selections did not fit.

Is there a way to make the Notes field mandatory only when Other is selected? Or is there something else I can do to ensure an explanation for Other is recorded?

Thanks,

Quote :
I do not fear computers. I fear the lack of them. - Isaac Asimov

_________________
cmckinney@searay.com

Will program for a Sea Ray 680 SS ;}

dataobjx

Posts: 181

Posted: 09/23/2004, 7:18 PM

Use The On_Validate event for the record.

If RECORD_NAME.other.value <> "" And RECORD_NAME.SomeField.Value = "" Then
RECORD_NAME.Errors.Error = "If other has a value SomeField must also be completed"
End If
_________________
www.DataObjx.net
www.mydigitalapps.com

These are Community Forums for users to exchange information.
If you would like to obtain technical product help please visit http://support.yessoftware.com.

MS Access to Web

Convert MS Access to Web.
Join thousands of Web developers who build Web applications with minimal coding.
CodeCharge.com

Home | Search | Members | Register | Login