How to filter a combo box?

i made a form that filters data before printing..the problem is,when i select all employee,the combo box beside the all employee checkboc doesnt filter the data...the data inside the items of the combo box is Alphabetical,employee type,pay type and pay group..the rest of the combo boxes data is from the data base...here's my code:

If ComboBoxAll.Text = "Alphabetical" Then
Employ += " AND last_name"
ElseIf ComboBoxAll.Text = "Emp Type" Then
Employ += " ORDER BY emp_type"
ElseIf ComboBoxAll.Text = "Pay Group" Then
Employ += " ORDER BY pay_group"
ElseIf ComboBoxAll.Text = "Pay Type" Then
Employ += " ORDER BY pay_type"
End If

Have you tried to troubleshoot it? You can put a breakpoint at the code which execute this query and use the immediate window to copy and paste the variable which holds this query to see if that query is correct or not.

ive tried it...but it doesnt work....the combo box needs to filter the data by alphabetical,emp type,pay tpye and pay group...it should also be in alphabetical order when you sort it by emp type,pay type and pay group...thanks