Requiring Fields based upon entry in a nother field

[dannyocean]

Hello All,


I am needing to make certain fields required in my form based upon the answer in another field.

EX. Market Field = Arizona Make Zip Code require an entry.

Thanks in advance,

Danny

 

[LittleSmudge]

Fields are found in tables

CONTROLS appear on Forms.


You can make FIELDS Required ( or Not )
You cannot make Controls Required

However, you can write some code in the Form's UnLoad event that will check to see if the data rules are satisfied and then CANCEL the Unload if they are not.

Eg
Private Sub Form_UnLoad(Cancel As Integer)
If Market = "Arizona" And IsNull(ZipCode) Then
Cancel = False
MsgBox " There must be a valid ZipCode for Arizona addresses."
End If

End Sub


'ope-that-'elps.

G LS
accessaceNOJUNK@valleyalley.co.uk
Remove the NOJUNK to use.

Please remember to give helpful posts the stars they deserve!
This makes the post more visible to others in need! :-D