I am trying to check if data is present in a specific table using vba. So far i have this line of code written but when i try to run it i get "invalid operation"
If CurrentDb.TableDefs("myTBL
").Fields(
"myField")
.Value Is Not Null Then
when i run it this way i get "object required"
If CurrentDb.TableDefs("myTBL
").Fields(
"myField")
Is Not Null Then
what am i doing wrong here.
Start Free Trial
