Cursor Control

[wllsth]

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

 

[MStef]

Try next:
In your subform put in CYCLE properties ALL RECORDS

 

[wllsth]

Tried that but still reverts back to my Main Form, I just want it to drop down to a new record within my sub-form !!

 

[wllsth]

I've sorted it thanks. I had a 'REQUERY' command which was refreshing totals. I've removed it and it works fine !!