I currently have the following line of code to see if number entered is a valid one in my MasterCellDevices table:
If DCount("connection", "MasterCellDevices", "[connection]='" & Me.txt_InvConnectionPhone & "'") > 0 Then
If it is a valid number I want to check to see if there is anything in the MasterCellDevices.ID field. If there is, I want a msgbox to pop up saying that it is already assigned to a different location. If it is null or empty I want it to update the field with the current ID.
I am struggling on how to figure out whether or not that field is empty or not.
Sorry if I didn't explain it enough, but I am new to coding and looking for help.
Thank you for your time and help.