asked on

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.

Jim Dettman (EE MVE)

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.

Jim Dettman (EE MVE)

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.

btgtech

ASKER

I do not want it to cycle to the main form, I am looking for it to cycle to the next record.

btgtech

ASKER

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

Jim Dettman (EE MVE)

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

Jim Dettman (EE MVE)

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

btgtech

ASKER

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

Jim Dettman (EE MVE)

So your trying to carry values forward to the next record, or are you updating the Revisedxxxx fields in the current record?

Jim.

btgtech

ASKER

Revised fields in the current record

ASKER CERTIFIED SOLUTION

Jim Dettman (EE MVE)

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial