set focus to subform

[SuzyQ]

I want code in the on exit event of a field in frmEmployeeProjects (subform
and parent) which is a subform of frmTimeSheet (parent).

Form frmEmployeeProjects has a subform named
frmTimeSheetsSubFormProjectEquipment

I want to set focus to the subform frmTimeSheetsSubFormProjectEquipment I
have tried several different ways and I get messages like
frmTimeSheetsSubFormProjectEquipment can't be found or invalid method

How can I set focus from frmEmployeeProjects to
frmTimeSheetsSubFormProjectEquipment which is a subform of
frmEmployeeProjects which is a subform of frmTimeSheet?

 

[Graham Mandeno]

Hi Suzy

Have you tried:

Me!frmTimeSheetsSubFormProjectEquipment.SetFocus ?

Note that frmTimeSheetsSubFormProjectEquipment should match the name of the
subform container control, which is not necessarily the same as the name of
the subform that it contains.

 

[SuzyQ]

I must have had an ! when I should have had a . or visa versa. But this
worked. Thanks.

Hi Suzy

Have you tried:

Me!frmTimeSheetsSubFormProjectEquipment.SetFocus ?

Note that frmTimeSheetsSubFormProjectEquipment should match the name of the
subform container control, which is not necessarily the same as the name of
the subform that it contains.
--
Good Luck

Graham Mandeno [Access MVP]
Auckland, New Zealand

I want code in the on exit event of a field in frmEmployeeProjects (subform
and parent) which is a subform of frmTimeSheet (parent).

Form frmEmployeeProjects has a subform named
frmTimeSheetsSubFormProjectEquipment

I want to set focus to the subform frmTimeSheetsSubFormProjectEquipment I
have tried several different ways and I get messages like
frmTimeSheetsSubFormProjectEquipment can't be found or invalid method

How can I set focus from frmEmployeeProjects to
frmTimeSheetsSubFormProjectEquipment which is a subform of
frmEmployeeProjects which is a subform of frmTimeSheet?

 

[SuzyQ]

One more question though... is there a way to set focus to a specific field
on a form rather than just to the form?

I want set focus back to subform frmEmployeeProjects which is one level up
from frmTimeSheetsSubFormProjectEquipment but I want to go to a specific
field (one after the field that sets focus to the equipment form.

Hi Suzy

Have you tried:

Me!frmTimeSheetsSubFormProjectEquipment.SetFocus ?

Note that frmTimeSheetsSubFormProjectEquipment should match the name of the
subform container control, which is not necessarily the same as the name of
the subform that it contains.
--
Good Luck

Graham Mandeno [Access MVP]
Auckland, New Zealand

I want code in the on exit event of a field in frmEmployeeProjects (subform
and parent) which is a subform of frmTimeSheet (parent).

Form frmEmployeeProjects has a subform named
frmTimeSheetsSubFormProjectEquipment

I want to set focus to the subform frmTimeSheetsSubFormProjectEquipment I
have tried several different ways and I get messages like
frmTimeSheetsSubFormProjectEquipment can't be found or invalid method

How can I set focus from frmEmployeeProjects to
frmTimeSheetsSubFormProjectEquipment which is a subform of
frmEmployeeProjects which is a subform of frmTimeSheet?

 

[Graham Mandeno]

Hi Suzy

I haven't coded this for a while so I'm relying on memory (which isn't what
it used to be!

I think you set focus to the subform control and THEN to the control on the
subform:

Me!MySubform.SetFocus
Me!MySubform.Form!MyControl.SetFocus
--
Good Luck

Graham Mandeno [Access MVP]
Auckland, New Zealand

One more question though... is there a way to set focus to a specific
field
on a form rather than just to the form?

I want set focus back to subform frmEmployeeProjects which is one level up
from frmTimeSheetsSubFormProjectEquipment but I want to go to a specific
field (one after the field that sets focus to the equipment form.

Hi Suzy

Have you tried:

Me!frmTimeSheetsSubFormProjectEquipment.SetFocus ?

Note that frmTimeSheetsSubFormProjectEquipment should match the name of
the
subform container control, which is not necessarily the same as the name
of
the subform that it contains.
--
Good Luck

Graham Mandeno [Access MVP]
Auckland, New Zealand

I want code in the on exit event of a field in frmEmployeeProjects
(subform
and parent) which is a subform of frmTimeSheet (parent).

Form frmEmployeeProjects has a subform named
frmTimeSheetsSubFormProjectEquipment

I want to set focus to the subform frmTimeSheetsSubFormProjectEquipment
I
have tried several different ways and I get messages like
frmTimeSheetsSubFormProjectEquipment can't be found or invalid method

How can I set focus from frmEmployeeProjects to
frmTimeSheetsSubFormProjectEquipment which is a subform of
frmEmployeeProjects which is a subform of frmTimeSheet?

 

[SuzyQ]

however in this case I'm in the bottom level subform and want to set focus up
one level to its parent which is a subform of the main form. Any suggestions?

I.E. Main Form -> Subform -> Subform's Subform

I'm in the subform's subform and want to get to a specific field in the
subform.

Hi Suzy

I haven't coded this for a while so I'm relying on memory (which isn't what
it used to be!

I think you set focus to the subform control and THEN to the control on the
subform:

Me!MySubform.SetFocus
Me!MySubform.Form!MyControl.SetFocus
--
Good Luck

Graham Mandeno [Access MVP]
Auckland, New Zealand

One more question though... is there a way to set focus to a specific
field
on a form rather than just to the form?

I want set focus back to subform frmEmployeeProjects which is one level up
from frmTimeSheetsSubFormProjectEquipment but I want to go to a specific
field (one after the field that sets focus to the equipment form.

Hi Suzy

Have you tried:

Me!frmTimeSheetsSubFormProjectEquipment.SetFocus ?

Note that frmTimeSheetsSubFormProjectEquipment should match the name of
the
subform container control, which is not necessarily the same as the name
of
the subform that it contains.
--
Good Luck

Graham Mandeno [Access MVP]
Auckland, New Zealand

I want code in the on exit event of a field in frmEmployeeProjects
(subform
and parent) which is a subform of frmTimeSheet (parent).

Form frmEmployeeProjects has a subform named
frmTimeSheetsSubFormProjectEquipment

I want to set focus to the subform frmTimeSheetsSubFormProjectEquipment
I
have tried several different ways and I get messages like
frmTimeSheetsSubFormProjectEquipment can't be found or invalid method

How can I set focus from frmEmployeeProjects to
frmTimeSheetsSubFormProjectEquipment which is a subform of
frmEmployeeProjects which is a subform of frmTimeSheet?

 

[John W. Vinson]

however in this case I'm in the bottom level subform and want to set focus up
one level to its parent which is a subform of the main form. Any suggestions?

I.E. Main Form -> Subform -> Subform's Subform

I'm in the subform's subform and want to get to a specific field in the
subform.

Me.Parent.SetFocus
Me.Parent!controlname.SetFocus

 

[Dirk Goldgar]

Me.Parent.SetFocus
Me.Parent!controlname.SetFocus

I don't believe you need to set the focus to the parent in this case. Just:

Me.Parent!controlname.SetFocus

.... should do it (unless that's changed in Access 2007).

 

[SuzyQ]

Thanks John and Dirk. I won't be able to try this until Monday, but I
appreciate the help. I'll followup if necessary.

 

[bouche vanessa]

salut jai un probleme jai telecharger un anti virus payant a pc tools je veu
resilier labonnement mai je trouve pas en plu c un abonnement 1 an a 29.95
par moi au secour comment je doit faire

Thanks John and Dirk. I won't be able to try this until Monday, but I
appreciate the help. I'll followup if necessary.

 

[SuzyQ]

Me.Parent.SetFocus - 'This code gave error message "invalid method in
expression"
thanks to all