Set focus in sub form

[Derrick T. Davidson]

I have a main form [frmTransactions] containing a sub form [fsubOfficeSuppliesCatBre]
I want to open the form go to the sub form and set the focus to the [CatBreBrand] fieldin the sub form.
I tried thefollowing code, with the resulting error message?

DoCmd.OpenForm "frmTransactions",acNormal, "", "", , acNormal
DoCmd.GoToRecord acForm,"frmTransactions", acLast
Me.fsubOfficeSuppliesCatBreak.SetFocus
Me. fsubOfficeSuppliesCatBreak!CatBreGrocBrand.SetFocu s

****************************************
Error
CompileError


Method orData Member Not Found
****************************************
What am I doing wrong ????

[azhar2006]

ok
DoCmd.OpenForm "frmTransactions", acNormal, , , , acNormal
DoCmd.GoToRecord acForm, "frmTransactions", acLast
Forms![frmTransactions]![fsubOfficeSuppliesCatBre].Form![TableNumber].SetFocus
DoCmd.Close acForm, "frmTransactions", acSaveYes

[ItsMe]

Me.fsubOfficeSuppliesCatBreak.Form.SetFocus

Be sure to use the Subform Container name and not the name of the Form object itself.

[Derrick T. Davidson]

Still no luck
It close's the [frmTransactions] so I omitted the last line and I inserted [CatBreBrand] in your [TableNumber] shown above it just opens in the first field of [frmTransactions]. I want to keep the [frmTransactions] open and go to the sub form within it [fsubOfficeSupplies] then set the focus to the CatBreBrand field about 50% of the way down??????

[Derrick T. Davidson]

Maybe I should explain the process, it may help.
1. Transactions are entered as a gross number for financial accounting etc
2. A sub form is visible in the Transaction form when certain criteria are met
3. If it is a new product / service then details of the style are entered i.e. by box, by kilo, etc. through a pop up which closes the transaction form
4. When details are entered in the pop up then a button is clicked to close the pop up and return to the last transaction form.
5. The Transaction form re-opens at the last record, showing the sub form also.
Here is where the issue is, rather than tab through all the transaction items and already completed items in the sub form, I want the transaction form to open and set the focus on the sub form and the Brand field within the sub form to complete the process.

[azhar2006]

Jump to mean last record of the subform

[azhar2006]

Private Sub fsubOfficeSuppliesCatBre_Enter()
DoCmd.GoToRecord , , acLast
End Sub


Private Sub Form_Current()
Forms![frmTransactions]![fsubOfficeSuppliesCatBre].SetFocus
End Sub

[Derrick T. Davidson]

Yes got it working thank you so much