Removing set focus

[Ruegen]

I have a subform with a memo field that has an on entry event (puts in a date in the field)



I have a listbox on the main form that requieries the subform on click - 1 to 1 id

The problem I have is because the subform has it's own focus, everytime I requery the subform it runs the event after the user has entered the field already.

I can't change the focus after the requery - I need a way to remove the focus on requery or at least "lose" focus.

any suggestions?

[Ruegen]

I've used recordsetclone.recordcount > 0

it resolves my issue but I was hoping for a better solution...