Form Flow 2

[drewcp]

I have a form for data entry

The links below show the same form in 'form view' and in 'design view'

http://qvepgq.bay.livefilestore.com...cg7jpA7IXyTNFvcoE-xPaCMBi8QmKV8/form view.bmp

http://qvepgq.bay.livefilestore.com...VSvyo98X9v-VDCkgRMgh8YbxpSl5s/design view.bmp

what my question is, is there a way to set up a continuous flow between the subforms so that you are not having to click into the next subform to continue data entry? instead of it going on the next record? especially since i removed the record selectors?

I have tried different things like before update on the form, and lost focus on the last field, and i tell it to go to the first record before it switches to the next subform, and it works but the odd thing is that sometimes it doesn't but nothing has changed. and it has started causing other problems as i have added more coding to the forms.

does anybody have any ideas for me? is this even accomplishable?

 

[Remou]

Have you tried setting the Cycle for the subforms to Current Record?

 

[drewcp]

thank you so much, that solved a lot of my problems with this.

do you know of an easier way to transition from subform to subform though? because there has got to be an easier way

here's the code that i am currently using to transition with
(it is in the lost focus of my last field on the subform)

Private Sub VISIT_DATE_LostFocus()
    DoCmd.Save
    Me.Parent![UTADBA_PARCEL].SetFocus
    DoCmd.GoToControl "Combo11"
End Sub

 

[PHV]

I'd replace this:
DoCmd.Save
with this
Me.dirty = False

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[Remou]

Not that I can think of. You do not need Save, that will happen automatically. GoToControl is deprecated by MS. How about:

Private Sub VISIT_DATE_LostFocus()
    Me.Parent![UTADBA_PARCEL].SetFocus
    Me.Parent![UTADBA_PARCEL].Form.Combo11.SetFocus
End Sub

 

[drewcp]

thank you both, i took both of your suggestions and it is working great! thank you very much for your help