C
CB
Is there a way to move the focus from a subform up to the
main form using a macro?
main form using a macro?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
D
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.
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.
C
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?
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?
D
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.
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.
C
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.
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.