Combo box that filters the rowsource

[billcar2006]

I have a combo box on a form that when I start typing it gives me a dropdown menu of all part names that start with what I type, then I can select which one I want and it goes to that record. This works fine with the code below. I want to add in another criteria.
I also have another combo box called cboMachine on the form, that's controlsource is Machine which is in the same table as part Name. I reckon I have to add to this line strRowSource = "SELECT ID, [Part Name] FROM [Part Details]"
What I need to put and where I don't know. If anyone could help that would be much appreciated.

Private Sub cbomachineSelect_Change()
Dim strRowSource As String
strRowSource = "SELECT ID, [Part Name] FROM [Part Details]"
If Len(Me!cbomachineSelect.Text) = 4 Then
strRowSource = strRowSource & " WHERE [Part Name] Like '"
strRowSource = strRowSource & Me!cbomachineSelect.Text
strRowSource = strRowSource & "*'"
Me!cbomachineSelect.RowSource = strRowSource
Me!cbomachineSelect.Dropdown
End If


End Sub

[June7]

This is cascading (dependent) combo/list boxes. Should be aware will not work nice in Datasheet or Continuous view.

I am not sure from your post which combo is dependent. Review http://www.datapigtechnologies.com/f...combobox2.html

[billcar2006]

The combos are not dependant. CboMachine gets its data from a machine table and puts it in part details table depending which machine I select with cboMachine. cboMachineselect I should have renamed to cboPartName to avoid confusion. This combo only jumps the form to the record with the part name selected in it. With this combo when I start type in the first 5 letters of the part name the combo drops down and shows all the part names in the table that begin with those 5 letters.
I have already filtered the form with the machine so it only shows the records for that machine. But when I type into the cboPartName combo it still shows all the part names because the code above is setting the record source from the table.

[June7]

Sorry then. Don't understand what you need.