I do not understand what I am doing wrong with this code.
It is supposed to work like this:
Click on one or more from the Manu list, which determines what is on the Segu list and Modu list.
Thank you in advance for any help you can give me.Code:Private Sub ListManu_AfterUpdate() Me.ListSegu.RowSource = "SELECT Seg" & "FROM BAMVtbl" & "WHERE Manufacturer=" & Nz(Me.ListManu) Me.ListModu.RowSource = "SELECT Model" & "FROM BAMVtbl" & "WHERE Seg=" & Me.ListManu End Sub