Hi,
below is the code is written in txtempno validate
''''
Me.objdsEmployee.EnforceConstraints = False
sCurrentValue = txtEmpNo.Text
Me.BindingContext(objdsEmployee, "employee").CancelCurrentEdit()
Me.objdsEmployee.Clear()
Me.BindingContext(objdsEmployee, "employee").CancelCurrentEdit()
Me.OleDbDataAdapterEmployee.SelectCommand.Parameters("employeeCode").Value = sCurrentValue
Me.OleDbDataAdapterEmployee.Fill(objdsEmployee)
Me.OleDbDataAdapter2.Fill(objdsEmployee)
Me.objdsEmployee.EnforceConstraints = True
''''

in the above code which point should i check fields are having null values..

please guide i'm new to VB.Net


Wrgds
Ganesh.K