MS Access Form Stay On Added Record

Hi Folks,
When I add a record  - after the record is created in the table - how do I ensure that the added record displays in the form instead of a blank form ready for another addition?
Thanks.
Bob CollisonSystem ArchitectAsked:
Who is Participating?
 
Dale FyeConnect With a Mentor Commented:
First, check the "Cycle" property, located on the Other tab of the property dialog box.  Set this value to "Current Record"

This way, when you reach the last field on the form, rather than automatically moving to the next record, the cursor will move back to the first field (by tab order) in the form.
0
 
Bob CollisonSystem ArchitectAuthor Commented:
Perfect. Simple solution!
0
 
Dale FyeCommented:
Glad I could help.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.