Unanswered: Incorrect syntax when referring to a table field in VBA
I'm trying to evaluate a condition from a form but apparently do not have the correct VBA syntax. Specifically, I want to determine whether a particular field is null within a make table when the user clicks on a form command button. I.E.
If "[Table Name].[Field]" <> "" Then..........
At first, I was receiving "MS Access can't find the field "|" referred to in your expression - Run time error '2465'" I eliminated that error by switching from () to "" around the table name and field. Now the If then statement is ignored.