Default value for field not appearing in Form. also, how to have the Default value for one of the field to "draw" from another related-table.

[Gasman]

the field is currently blank at the moment, so the field is NULL? it can't be a ZLS since it is a number? right?

TBH, I would have to test. though I seem to recall that could be the case.

However if you walk through your code with F8 you will see what it does.?
The code looks fine to me, so either the test is Null or nothing is in the 4th column.
Walking through the code and hovering over the variables/controls will show that once and for all?


Basic VBA debugging 101.