Unexpected run-time error on MS Access form
Posted on 2015-02-17
Something bizzare is going on.
I have a data entry form with a bunch of unbound textboxes and one bound textbox that is bound to a foreign key field. When I open the form, I open it filtered to the value of the foreign key. For new entries, there won't be a value there, as expected, so I trap for a null value. That now fails in the trapping WFT!?!
I am getting a run-time error '-2147352567 (80020009) You entered an expression that has no value.
Of course it has no value. It's on a form that is filtered to having no records by design.
So I trap it.
Dim TheJobID As Long
TheJobID = Nz(Me.JobID, Forms!frmFieldReport!JobID)
Except the error is now happening within the trap.
Any idea what has changed that this no longer works?
The backend is SQL Server.