changing from d_t_got_focus to bdo_afterupdate give error 424

[ano]

i was tired to see info that is only for qry by lack of rownum


so i decide to hide it, realizing no focus anymore i decide to go next item in after update
and can not find why it give an error on the visible and not on the hidden
and the error line works in direct window
and d_d_gotfocus no problem in bdo_afterupdate

'old situation visible but useless info
Private Sub d_d_GotFocus()
If Forms!balans!bl!d_d = 0 Then
Forms!balans!bl!d_d = DCount("d_d", "bl") + 1
End If
End Sub


Private Sub d_t_GotFocus()
' old situation visible but useless info
If FindValue(Format(Forms!balans!bl!dt, "mmdd"), "0131", "0228", "0331", "0430", "0531", "0630", "0731", "0831", "0930", "1031", "1130", "1231") Then
If Forms!balans!bl!d_t = 0 Then 'was already changed to null and 1st condition
Forms!balans!bl!d_t = DMax("d_t", "bl") + 1
End If
End If
End Sub


Private Sub bdo_AfterUpdate()
'new situation but d_t datasheetcaption " " d_t has same color back/fore ground rule needed the space to align
' d_t is meanwhile changed from 0 to null to create unique index and run in old situation already
  '  If Forms!balans!bl!d_t Is Null Then '?Forms!balans!bl!d_t --> null ,line but give error 424 object required, so out comment waiting to find solution. .value was also wrong
    If FindValue(Format(Forms!balans!bl!dt, "mmdd"), "0131", "0228", "0331", "0430", "0531", "0630", "0731", "0831", "0930", "1031", "1130", "1231") Then
    Forms!balans!bl!d_t = DMax("d_t", "bl") + 1
 '   End If
    End If
    If Forms!balans!bl!d_d = 0 Then ' d_d is hidden
    Forms!balans!bl!d_d = DCount("d_d", "bl") + 1
    End If
End Sub

[ano]

is it really true?
in gotfocus i had to change "= null" into "is null" (which make it running) and na i needed back to "= null" what is the logic?

[Minty]

In Access/SQL nothing ever = null not even Null = Null

That why you have specific functions to check for Null values - either IsNull() for a control or Is Null in a query.

You can prove this in the immediate window:

? Null = Null
Null

[ano]

In Access/SQL nothing ever = null not even Null = Null

That why you have specific functions to check for Null values - either IsNull() for a control or Is Null in a query.

You can prove this in the immediate window:

? Null = Null
Null

it is neither in a control nor in a query it is in an if search 'access vba if null' in bing i did not get isnull() so i used =null which was wrong so i changed into is null which was working correct. till i decide to hide and focus not would work. so i change d_t_gotfocus into bdo_afterupdate and copy the d_d under it
so a working line with other procedure name stop working searching give no clue direct window give no error. changing "is" back to "=" was the solution but why

[Minty]

Forms!balans!bl!d_t is a control? and I assume this code is on that form ?
In which case the correct syntax to use would be either

If IsNull(Forms!balans!bl!d_t ) then

or

If IsNull(me.d_t) then

[ano]

btw ? in direct window reacted correct on the control so the control was not wrong used as dutch suggested qualifier needed (ur previous)
yeah u right just dont understand it work without it and i not find that function 1st time. so nxt time problem i put function tnx tc enjoy