Trouble with setfocus on Subform

[ineedahelp]

I keep getting an error "object doesn't support this property or method" whenever I try to set the focus to the control [DatePerformed] on my subform. NOTE: it is a new record which may be an issue... (I added the stars to highlight for purposes here)

Private Sub cmbAddTask_Click()
Dim strAnswer As String
Dim Msg, Style, Title
        
    Forms!frmTravelExpense!subfrmTravelExpense.Form.AllowAdditions = True
    Me.SetFocus
    Me.subfrmTravelExpense.SetFocus
    'Forms!frmTravelExpense!subfrmTravelExpense.Form.SetFocus
 **   DoCmd.GoToRecord , , acNewRec
    'Forms![frmTravelExpense]![subfrmTravelExpense].Form![MemberID].SetFocus
    Forms!frmTravelExpense!subfrmTravelExpense.Form![MemberID] = Me.MemberID
    Forms!frmTravelExpense!subfrmTravelExpense.Form![Description] = "Travel Expense"
 **   Forms!frmTravelExpense!subfrmTravelExpense.Form![DatePerformed].SetFocus
    Forms!frmTravelExpense!subfrmTravelExpense.Form.AllowAdditions = False

Im also having trouble with the following code which I have in my onopen event.

DoCmd.GoToRecord , , acFirst
    'Forms!frmTravelExpense!MemberID.SetFocus
    Forms!frmTravelExpense!MemberID = mMemberID
    Me.subfrmTravelExpense.Form.Filter = "[Description] = 'Travel Expense'"
    Me.subfrmTravelExpense.Form.FilterOn = True

I get errors on the setfocus line and the assignment to my field MemberID. Thank you for any help!

 

[LarrySteele]

You might be having problems referencing your subform. I never can remember how to format the references, so I use Keri Hardwick's document from the AccessWeb: Refer to Form and Subform properties and controls.

HTH,
Larry

 

[PHV]

code which I have in my onopen event
Use the Load event instead.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[ineedahelp]

Thank you very much for all your suggestions. The Load event helped and my problem has been solved.