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

Access Subform - The Form is set to cycle all records and it stops at the last field of the record

I have a subform that I have setup to capture data about an order.  It tabs through all of the fields to the last field and then it does not move on to the next record.  The only way to get out of the record is to press ESC.

I would like it to move to the first field of the next record.

Ont eh Form Properties I have the Cycle set to All records.

Please help.
0
btgtech
Asked:
btgtech
  • 6
  • 4
1 Solution
 
Jim Dettman (Microsoft MVP/ EE MVE)PresidentCommented:
Are you changing the record (it may not be passing some validation some where)?

Is this within a form that has a main/subform combination?

Jim.
0
 
Jim Dettman (Microsoft MVP/ EE MVE)PresidentCommented:
Scratch the last; just saw the title of the question!

Understand that it will only cycle within the subform...it's not going to jump out back to the main form (Ctrl/Tab will).

Jim.
0
 
btgtechAuthor Commented:
I do not want it to cycle to the main form, I am looking for it to cycle to the next record.
0
Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

 
btgtechAuthor Commented:
I have an Event that happens in the After Update Event of the form.  I removed that and it cycle thru as expected to the next record.

What I am trying to do is that we have the user entering plan hours and dates on the subform.  Once they have entered the data, then I set the revised hours and dates to equal the plan data as a starting point for the next form so that they only make updates to the revised data on the next form.

1. Should I add an after update event on each of the fields to do this rather than once at the form level?
2. Is there a better event to place this code in?

Thanks
0
 
Jim Dettman (Microsoft MVP/ EE MVE)PresidentCommented:
<<Ont eh Form Properties I have the Cycle set to All records.>>

 Just to double check, it's the subforms cycle property you've set, correct?

If so, then I would look for code that:

1. Stops the record from being saved (BeforeUpdate of the form is being canceled).

2. You don't have any special code trying to control the tabbing order within the subform.

If neither of those is a possibility, bounce back.

Jim.
0
 
Jim Dettman (Microsoft MVP/ EE MVE)PresidentCommented:
<<What I am trying to do is that we have the user entering plan hours and dates on the subform.  Once they have entered the data, then I set the revised hours and dates to equal the plan data as a starting point for the next form so that they only make updates to the revised data on the next form.>>

 Not sure I'm following that....can you post the code from the AfterUpdate please.

Jim.
0
 
btgtechAuthor Commented:
Private Sub Form_AfterUpdate()
'   Me.RevisedCutSawStart = Me.[20START]
'   Me.RevisedCutSawComplete = Me.[20COMP]
'   Me.RevisedBrakeStart = Me.[22START]
'   Me.RevisedBrakeComplete = Me.[22COMP]
'   Me.RevisedPlasmaStart = Me.[24START]
'   Me.RevisedPlasmaComplete = Me.[24COMP]
'   Me.RevisedWeldStart = Me.[30START]
'   Me.RevisedWeldComplete = Me.[30COMP]
'   Me.RevisedCleanStart = Me.[40START]
'   Me.RevisedCleanComplete = Me.[40COMP]
'   Me.RevisedPaintStart = Me.[45START]
'   Me.RevisedPaintComplete = Me.[45COMP]
'   Me.RevisedAssemblyStart = Me.[50Start]
'   Me.RevisedAssemblyComplete = Me.[50COMP]
'   Me.RevisedCutSawHours = Me.PlanCutSawHours
'   Me.RevisedBrakeHours = Me.PlanBrakeHours
'   Me.RevisedPlasmaHours = Me.PlanPlasmaHours
'   Me.RevisedCleanHours = Me.PlanCleanHours
'   Me.RevisedWeldHours = Me.PlanWeldHours
'   Me.RevisedPaintHours = Me.PlanPaintHours
'   Me.RevisedAssemblyHours = Me.PlanAssemblyHours
   
End Sub
0
 
Jim Dettman (Microsoft MVP/ EE MVE)PresidentCommented:
So your trying to carry values forward to the next record, or are you updating the Revisedxxxx fields in the current record?

Jim.
0
 
btgtechAuthor Commented:
Revised fields in the current record
0
 
Jim Dettman (Microsoft MVP/ EE MVE)PresidentCommented:
<<Revised fields in the current record >>

 You want the code in the BeforeUpdate event.  In AfterUpdate, the that's too late...the records is already saved.

Jim.
0

Featured Post

Learn to develop an Android App

Want to increase your earning potential in 2018? Pad your resume with app building experience. Learn how with this hands-on course.

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