trouble with focus going from a subform combo to a main form button

[jaymin]

Hope someone can put me staright, i have a form with a subform that i enter data with, on the last combo box i have a subroutine that should take me to a button on the main form i am using this

Me.Parent!cmbClose.SetFocus

as the code in the "afterupdate" event. I keep getting an error message "can't move the focus to the control cmbClose"
I have used the format from the link below.
http://access.mvps.org/access/forms/frm0031.htm or if there is another way to achieve the same outcome.

Also i get this error message "search key was not found in any record"

Me!sbfNew_PPE.Form!cboFitting.Enabled = False

I have tryed to check on the forum for clues and it seems the problem occures with spaces when importing any files.



Peter

[June7]

I have never used the Parent qualifier. I reference forms explicitely.

Forms!mainformname.cmbClose.SetFocus
or in VBA can also use
Form_mainformname.cmbClose.SetFocus

Is sbfNew_PPE the name of the subform or the container control that holds the form object? I always give container control a name different from the object (table, query, form, report) it holds, like ctrPPE.
Me.ctrPPE.Form.cboFitting.Enabled = False

I use dot (.) instead of bang (!) when referencing controls because it provokes intellisense popup tips.

[jaymin]

June7
Thank you for your help
Peter