I have a form that generates a number incrementally automatically. This was set by selecting auto number in the table properties. I would like that exact number to be entered in another field as soon as someone tabs into the first field in the tab order. The field to be populated by this process is a key in the underlying table.
I have tried the following vba code with no sucsess.
Private Sub Tally_Number_Click()
If Me!autoTnumber = Not Null Then
Me!TallyNo = Me!autoTnumber
End If
End Sub
My thinking was that when the field with the autonumber is populated, it will not be null and the condiotional statement would then populate the apropriate field with the autonumber.
Suggestions?
I have tried the following vba code with no sucsess.
Private Sub Tally_Number_Click()
If Me!autoTnumber = Not Null Then
Me!TallyNo = Me!autoTnumber
End If
End Sub
My thinking was that when the field with the autonumber is populated, it will not be null and the condiotional statement would then populate the apropriate field with the autonumber.
Suggestions?