Can Some one please reply..i am in real need of help
________________________________ From: Lonnie Johnson <[email protected]> To: [email protected] Sent: Wed, April 28, 2010 6:57:00 PM Subject: Re: [ms_access] Validation Rule : If you fill in Field1, Field2 is required also..NOT WORKING 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 <microaccess80@ yahoo.com> To: ms_acc...@yahoogrou ps.com 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] [Non-text portions of this message have been removed]
