Replace with NULL Value On Search

Vote count:

0

In my form I have a search function setup to where I can type in any of the fields and search for that particular data, the course fields though need to be CLEARED if I have not preselected something for their fields. I have their default values at null. Currently the code looks like

Private Function SearchClear()
Me.cboDevelopment1 = ""
Me.cboDevelopment2 = ""
Me.cboDevelopment3 = ""
Me.cboDevelopment4 = ""
Me.cboDevelopment5 = ""
'focus on ID text box
Me.txtEmpID.SetFocus
'set button edit to enable
Me.cmdEdit.Enabled = True
'change caption of button add to Add
Me.cmdAdd.Caption = "Add Record"
'clear tag on txt id for reset new
Me.txtEmpID.Tag = ""
End Function 

I would like to write in saying IF NULL then to clear the fields, but if not then let them be so the designated courses can be looked up.

asked 14 secs ago

user2119980

152