Simple-Moderate Question: Why isn't this Form_Open VBA Code working

[Bill Bisco]

I have a form and a subform. I'm trying to use the Form_Open Command to affect the Subform. Here is my code:

Private Sub Form_Open(Cancel As Integer)

'Me!frmProcessSelectLSSubform.Form!OrderBy = "ProcessSEQ"
'Me!frmProcessSelectLSSubform.Form!OrderByOn = True

'Forms!frmProcessSelectLSRS!frmProcessSelectLSSubform.Form.OrderBy = "ProcessSEQ"
'Forms!frmProcessSelectLSRS!frmProcessSelectLSSubform.Form.OrderByOn = True

Me!frmProcessSelectLSSubform.OrderBy = "ProcessSEQ"
Me!frmProcessSelectLSSubform.Form.OrderByOn = True

'Me!frmProcessSelectLSSubform.Form!OrderBy = "ProcessSEQ"
'Me!frmProcessSelectLSSubform.Form!OrderByOn = True

End Sub

For some reason. It thinks that I'm trying to refer to a field when I'm trying to Orderby. Any help is appreciated.

Sincerely,
Bill

 

[boblarson]

1. is this code on the main form or subform?

2. You use a period between .Form and the OrderBy (.Form.OrderBy) and not the bang (!).

 

[Bill Bisco]

1. Yeup, I'm on the Main form trying to affect the Subform.

2. Yes, I used a period and not a !, as you can see in my uncommented part. I'm still having trouble though and I don't know why

 

[boblarson]

One more question - Are you sure you are referencing the name of the subform CONTAINER (the control on the main form that houses the subform) and not the subform (unless they are the same exact name then it is okay).

 

[Bill Bisco]

Bob you're a genius. Wish I had thought of that.

You've helped a bunch.

Thanks,
Bill

 

[boblarson]

Bob you're a genius. Wish I had thought of that.

You've helped a bunch.

Thanks,
Bill

Cool, glad to hear!