Hi,
Can some help me. I'm not sure of the syntax
I wanted to double click in text box and Add the LastRtgNo + 1
I have this. The way I wrote the [LastRtgNo] + 1 is not right.
I tried with a ([LastRtgNo]) + 1 and a few other ways Can't figuire it out
Private Sub RtgNo_DblClick(Cancel As Integer)
If IsNull(RtgNo) Then
RtgNo = [LastRtgNo] + 1
Else
RtgNo = Null
End If
End Sub
Thanks.
Can some help me. I'm not sure of the syntax
I wanted to double click in text box and Add the LastRtgNo + 1
I have this. The way I wrote the [LastRtgNo] + 1 is not right.
I tried with a ([LastRtgNo]) + 1 and a few other ways Can't figuire it out
Private Sub RtgNo_DblClick(Cancel As Integer)
If IsNull(RtgNo) Then
RtgNo = [LastRtgNo] + 1
Else
RtgNo = Null
End If
End Sub
Thanks.