Automatically move to next record

  • Thread starter Terry DeJournett
  • 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
 
F

fredg

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!!!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Validating a Field 5
Access Automatically Send a notification email once a record is added 0
Automatically highlight duplicate value 1
auto move 6
converting number data to text and formating 2
How to automatically move to next field after Bar/EAN code entry? 1
Auto Tabbing upon entry 9
How to move to the end of a field to insert text 2

Top