MOVE FOCUS FROM SUBFORM

[CB]

Is there a way to move the focus from a subform up to the
main form using a macro?

 

[Don Wilson]

I do not know how to do this with a macro, but using an
event procedure "On Lost Focus" of the last field on the
subform you could add 1 line of code.

DoCmd.GoToControl "Forms!frmMain!FieldName

This would produce the result you are asking for.

I hope that helps.

 

[CB]

Don,
Thanks for the suggestion.
I'm not sure how to use it...
What I am trying to do is:
select a value on the main from (in a combo-box) - and
filter on that value for the subform.
Then I have up a macro-condition, on exit combo-box, to
test the combo box (if null...msgbox).
NOW I want the focus to stay on the combo-box, but it
keeps jumping into the subform.
My approach (unsuccessful) is to setfocus on the combo-
box - but I'm stuck in the subform...

any ideas or suggestions?

 

[Don Wilson]

Well, at this point i would need to see the database.
I dont mind helping, in fact i seem to learn something new
everytime i do actually help someone.

You can send me the database if you'd like.
Just please be sure to zip it.

Send to (e-mail address removed)

If there file is more then 3 megs please delete the
existing data before zipping.

 

[cb]

Don,
Thanks again for your reply.
I found a work-a-round...I don't use the subform as a
subform. I just open it as a new form, edit and close.
Problem solved...just not as "neat"
Thanks again for being there.