Combo Box filter

[Hubba]

Hi All,
Just after a code or way to filter client details via a combo box.
Basically select combox drop down menu select the sales rep then it filters by sales rep and shows only the clients for that sales rep. I can get it to filter but it does the first client of that sales rep but not the rest.

Thanks
Karl

 

[Robert88]

Hi Hubba,

Sounds like cascading combo boxes.

Try this connection;

http://www.fontstuff.com/access/acctut10.htm

Robert88

 

[Hubba]

Actually you maybe right on that one
Cheers
karl

 

[Hubba]

Had a look, close but need it to filter which this doesn't
Code below is from this which i have changed
Private Sub Reps_AfterUpdate()
On Error Resume Next
cboReps.RowSource = "Select tblrep.field1 " & _
"FROM tblrep " & _
"WHERE tblsheet1.Rep = '" & cboReps.Value & "' " & _
"ORDER BY tblsheet1.Rep;"
End Sub

But need to have a filter so it turns the filter on when we select the sales rep from the combo box

Thanks
karl

 

[ansentry]

Have a look at the attached sample, I think this is what you want to do.