Bill Bisco
Active Member
- Joined
- Aug 8, 2007
- Messages
- 446
I have a form and a subform. I'm trying to use the Form_Open Command to affect the Subform. Here is my code:
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
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
Sincerely,
Bill