what does this mean? (1 Viewer)

[raymond3090]

Hi,
Can somebody tell me explain to me what the purpose of this piece of code is? It came from form properties.

Private Sub Form_Current()
If IsNull(Me![RecordingID]) Then
DoCmd.GoToControl "RecordingTitle"
End If
End Sub

thanks!

Ray

 

[Drevlin]

Simply put when you move to the current data in your form (i.e. Clicking the Next Record Arrow) It looks to see if there is any information in [RecordingID] which is either a control on the form or a Field in the form's Query (which doesn't necessarily have to be on the form itself). If it has no information then the focus/cursor is moved to the control named "RecordingTitle" (more then likely a text box but not necessarily). If there is information in [RecordingID] then the focus would go to the default control.

Peace