Hi All,
I have a Search form using a combo. The program is already running but I want the output to be in ascending order. The program is below.
Private Sub cboDocType_AfterUpdate()
Dim myCompany As String
myDocumentType = "Select * from tbl_Incoming where ([Doc_Type] = '" & Me.cboDocType & "')"
Me.tbl_Incoming_subform.Form.RecordSource = myDocumentType
Me.tbl_Incoming_subform.Form.Requery
End Sub
Hope somebody can help.
Thank you!