One field dependent on another

[dogs4kids]

In a form, I have a combo box from which the user can select either Phone or Email. I also have an Email text box on the form. How can I make the Email text box field required only when Email is selected in the combo box?

Thanks for the help.

 

[boblarson]

If the combo returns the TEXT of "Email" when selected, you can use this in the Combo's AFTER UPDATE event:

Me.YourEmailTextBoxNameHere.Visible = (Me.YourComboBoxNameHere = "Email")

 

[boblarson]

Or I guess you can unlock it.

As for "Required" you would need to validate it in the form's BEFORE UPDATE event something like:

If Me.YourComboBoxNameHere = "Email" And Len(Me.YourEmailTextBoxNameHere & "")=0 Then
   MsgBox "You must fill in an Email address if you have selected Email", vbExclamation, "Error"
   Cancel = True
End If