G
Gator
I have a Table with ID's like....010101, 010102, 020101, 020102,....
First, I want to make list0 show distinct first two numbers, like....
01
02
03
then I want list2, which will contain the full numbers to be filtered by
those first two numbers from list0's selection.
Something like,
list0_click
list2.RowSource="Select ID FROM Table1 WHERE ***FIRST TWO LETTERS IN
LIST2(TABLE1) ARE LIKE LIST0
many thanks
First, I want to make list0 show distinct first two numbers, like....
01
02
03
then I want list2, which will contain the full numbers to be filtered by
those first two numbers from list0's selection.
Something like,
list0_click
list2.RowSource="Select ID FROM Table1 WHERE ***FIRST TWO LETTERS IN
LIST2(TABLE1) ARE LIKE LIST0
many thanks