If Checkbox Is Unchecked Then Combo Box Required Web Database

[turntabl1st]

Name: Capture.PNG  Views: 15  Size: 10.1 KB  ID: 8666" class="thumbnail" style="float:CONFIG" />

I have a checkbox in a web database that if left unchecked i would like to be able to have the ability to make two combo boxes and one text box field required before saving a record on a form

notsciquest ------> scicategory, sciuom, and sciproductsize

any help creating a macro or a way to do this would be greatly appreciated!!

thanks!

[jameslarsen]

The way I would do this is on the submit command. Do a nested if statement to first check if the checkbox is checked, and if it is, to see if any of the "required" fields are populated. Pseudo-code below:

If Checkbox = 1 Then
(
If Field1 = null Or Field2 = null Or Field3 = null Then
Msgbox("Fields 1, 2, and 3 are required.")
Exit Sub
)
Submit Form

If the checkbox is not checked, or the checkbox is checked and all the fields are populated, then the form is submitted, otherwise, it exits. I hope this makes sense and helps you out. Let me know if you have any questions.

[turntabl1st]

How would this fit into a macro for a web database?

[turntabl1st]

Here was the solution for anyone interested.. Also this was a subform within a form so your variables may be different