when I run my program it goes runtime 94 invalid use of null?
what is this null? does it mean nothings inside?
Code:
Dim i As String
Set db = OpenDatabase(App.Path & "\DentalRecordSystem.mdb")
i = "select * from BS1D where LastName = " & "'" & txtSearch & "'"
Set rec = db.OpenRecordset(i, dbOpenSnapshot)
If rec.EOF = False Then
txtPatientRef = rec!PatientRef
txtLast = rec!LastName
txtFirst = rec!GivenName
txtMID = rec!MiddleName
txtID = rec!ID
txtOcc = rec!Occupation
txtCitizenship = rec!Citizenship
txtBday = rec!Birthday
txtAge = rec!Age
txtOffice = rec!OfficePhone
txtHouse = rec!HousePhone
txtMobile = rec!Mobile
txtFax = rec!Fax