Setfocus going to a new record in subform

[RCurtin]

Hi,
For some reason when I set the focus to a text box in the subform it clears the textboxes there.
First I set the values of 2 of the textboxes in the subform programatically. Then I tab to the last control in the main form. This is the code I have in the lost focus event of that control:

Forms!frmDrawingsRegister!frmDrawingRevisions.SetFocus
   Forms!frmDrawingsRegister!frmDrawingRevisions!txtLatestIssueDate.SetFocus

frmDrawingsRegister = main form
frmDrawingRevisions = subform

I have set the Cycle property of the subform to Current Record.

Why would this be happening?

 

[RCurtin]

Sorted it out!

I found the problem - I had a me.requery in the form load event of the subform!