I have a list box that generates a query... below is the code and the picture.
Private Sub cmdFindParts_Click()
Dim SeriesID As Integer
SeriesID = lst3.Value
If SeriesID = 1 Then
.ColumnCount = 3
.ColumnHeads = True
.RowSourceType = "Table/Query"
.RowSource = "SELECT Parts.PartID, Parts.Description, Parts.Series WHERE Part.Series = [Forms]![Form1]![lst3] FROM Parts"
Thanks for the help... I cant get it to only show the ones for that series.