Search results

I've the following validation code on a data entry form Private Sub CboCommCode_Exit(Cancel As Integer) If IsNull(Me.CboCommCode) Or Me.CboCommCode = "" Then MsgBox "Community is required! Enter community or select from list!" Me.Undo Cancel = True End If End Sub after the user...

I'm using Access 2003 form as front end connecting to sql server 2000 backend via DSN to enter data to one table tblActivity. I need to validate four fields on the form to ensure that the user does not enter duplicate info into tblActivity. the columns are Community, Building, Unit, and Task...