We help IT Professionals succeed at work.
Get Started
Lookup a field to see whether or not it is null or has a value
Hi all.
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.
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.
Why Experts Exchange?
Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.
Jim Murphy
Programmer at Smart IT Solutions
When asked, what has been your best career decision?
Deciding to stick with EE.
Mohamed Asif
Technical Department Head
Being involved with EE helped me to grow personally and professionally.
Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question
Connect with Certified Experts to gain insight and support on specific technology challenges including:
- Troubleshooting
- Research
- Professional Opinions
Did You Know?
We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE