Automatically move to next record

  • Thread starter Thread starter Terry DeJournett
  • Start date Start date
T

Terry DeJournett

I have a form that when I enter information into the last field, I would
like it to automatically move to the first field of the next record, BUT I
would like it to move as soon as the user enters all 6 digits without the
user having to hit enter or tab.(only 6 digits can be entered and 6 digits
are required)

Can this be done?

Thanks,
Terry
 
I have a form that when I enter information into the last field, I would
like it to automatically move to the first field of the next record, BUT I
would like it to move as soon as the user enters all 6 digits without the
user having to hit enter or tab.(only 6 digits can be entered and 6 digits
are required)

Can this be done?

Thanks,
Terry
Click to expand...

Code the control's Change event:

If Len(Me![ControlName].Text) = 6 Then
DoCmd.RunCommand acCmdRecordsGoToNext
End If

I hope the user enters the correct last digit!!!
 
Back
Top