Recent content by jgalbraith

Fantastic! I have one more twist thrown to me yesterday. Here is my code that works so far: (And yes, there is a spelling error in their field names :) ) Private Sub Form_BeforeUpdate(Cancel As Integer) If Form_INSERIMENTO.DRAWING_APDATE_REQUIRED = True And...

Thanks! Ok, so using the following, how do I have it check to make sure the DRAWING UPDATE REQUIRED checkbox is checked first? If the box isn't checked, the date isn't required. If Len(INSERIMENTO.DRAWING UPDATE DATE & vbNullString) = 0 Then MsgBox "You need to fill out Date Required"...

Hi, I have searched the threads but haven't found exactly what I need. You'll have to forgive the form/field names, my parent company is Italian and I am working with an existing database Form: INSERIMENTO Checkbox: DRAWING UPDATE REQUIRED Date Field: DRAWING UPDATE DATE Text Field: DRAWING...