You could put this in your form's Before Update event. If IsNull(FIELD1) = False And FIELD1 <> "" Then If IsNull(FIELD2) = True Or FIELD2 = "" Then FIELD2.SetFocus FIELD2.BackColor = vbYellow MsgBox "You must enter a value in Field2", vbCritical Exit Sub Else FIELD2.SetFocus FIELD2.BackColor = vbWhite End If End If
________________________________ From: microaccess80 <[email protected]> To: [email protected] Sent: Tue, April 27, 2010 12:58:28 PM Subject: [ms_access] Validation Rule : If you fill in Field1, Field2 is required also..NOT WORKING Hello ([Field1] Is Null) OR ([Field2] Is Not Null)is not working for "If you fill in Field1, Field2 is required" in Both Tables and Forms I have Fiedl 1 as Blood Pressure Systolic I have Field 2 as Blood Pressure Diastolic Both fielda are "number" format I am not very good with codes, so i am trying validation rules. If simple VBA codes can work for this, than i can do that. Please help. I am very much in need. Really hoping for a reply [Non-text portions of this message have been removed]
