Hi there tried creating new entry, it only works when the database is decompreste? weird I know.

can anyone help ?

thanks

PS: see code below

Code:
Dim HospitalNumber As String
Dim strSQL0 As String
dim LastName As String
Dim FirstName As String
Dim strDOB As String

If IsNull(Me.Text0.Value) Then
strHospitalNumber = " Like '*' "
Else
strHospitalNumber
...