How to move focus from sub to main form?

[glen]

Hello,
I have a main form with sub form.
there is one combo1 in main form.
in sub form there is a control named orderdate.



i put in sub form before update event this code but this is not move the focus on combo1.
Plz tell me where is problem.
thanks

If Len(forms!main.combo1 & vbNullString) = 0 Then
  MsgBox "select combo1 first"
  Cancel = True
  forms!main.combo1.setfocus
End If

[pbaldy]

I suspect that since you've cancelled the subform's update, focus can't move from it. Why would you test a main form field from the subform? I would think you'd check it in the main form's event.

[glen]

yes from Main form event this code is working.But I want to move from sub form.
I also studied this table but didn't get.
http://access.mvps.org/access/forms/frm0031.htm

[pbaldy]

But by cancelling the update you're telling Access you don't want focus to leave the subform.

[glen]

if possible suggest some other code for me according my need.
But from sub form, not from main form.
if not possible then thanks.