FORM CLOSES AND DOESN´T SET FOCUS TO OTHER FORM

[fsweb2002]

Hi

I have a FORM ("Quotes&quot which opens another form ("Clients&quot when I double click on a field.
The "clients" form has a cmdclose button with the following code in it...
Everything works fine HOWEVER the original FORM [Quotetype] field doesn´t get the FOCUS with the code below.
So I have to click on the form again to continue working with it...

What am I doing wrong ?

Thanks in advance.


Private Sub cmdclose_Click()

If IsLoaded("Quotes&quot Then
Form_Quotes.ClientName = Me.ClientName
Forms!quotes.ClientName.SetFocus
Forms!quotes.ClientName.Requery
Form_Quotes.QuoteLines_Subform.Form![QuoteType].SetFocus

Else

End If
DoCmd.Close
End Sub

 

[seb2]

I think its....

Forms!MainForm!Subform.SetFocus

i.e.

Forms!Form_Quotes!QuoteLines_Subform.SetFocus

 

[Gazer44]

Yes.

Forms![FormName]![FieldName].SetFocus

 

[fsweb2002]

dear seb2,

sorry, I´ve tried Forms!Form_Quotes!QuoteLines_Subform.SetFocus but it doesn´t work (error 2450 form "Form_Quotes" cannot be found.

But the form Quotes does exists for sure...

Anymore ideas...??

 

[seb2]

If you are sure there aren't any typos, perhaps you need to actually refernce a field of the subform that has focus and not jus the entire form.

Forms!Form_Quotes!QuoteLines_Subform!Quote_Id.SetFocus