• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 174
  • Last Modified:

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.
0
Bob_Collison
Asked:
Bob_Collison
  • 2
1 Solution
 
Dale FyeCommented:
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_CollisonAuthor Commented:
Perfect. Simple solution!
0
 
Dale FyeCommented:
Glad I could help.
0

Featured Post

How to Use the Help Bell

Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention.  Check out this how-to article for more information.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now