Cursor Control

[willsth]

I have a Main-Form with 2 sub-forms and I am using the sub-forms for data entry.

The problem I have is that when the user completes an entry on the sub-form the cursor moves back to the Main-Form and I want it to move to a new record on the appropriate sub-form.

How do I achieve this ??

 

[Remou]

You could use the Lost Focus event of the last control on subform 1 to move to the first control on subform 2

Private Sub ControlZ_LostFocus()
'You need two jumps
Me.Parent.Subform2ControlName.SetFocus
Me.Parent.Subform2ControlName.Form.ControlA.SetFocus
End Sub

 

[willsth]

Sorry what I meant to say was that I want the cursor to remain within the sub-form that I'm entering data into, just to jump to a new record !!

 

[Remou]

That is what would happen in a subform set up normally. This implies that you have changed something. Does your subform have coding that jumps the cursor to the main form?

 

[willsth]

You're right I put in a re-query command to refresh totals - I've just removed it and it seems OK

Thanks