Hi,
I am new to VBA, I am trying to create a form that will take the DISTINCT values of a one column and then display all the records associated to that value in the form. I am not sure how clear was that, but this example will make it clear. I have this table with two columns Supplier and the PartNo.
Supplier PartNo
A 1
A 2
A 3
B 1
B 2
C 1
I want to create a form that will be like this (there is a tab between the alpabets and the numbers. due to some reason on posting they are very close to each other).
Supplier 'A'
Parts
1
2
3
The next record will be
Supplier 'B'
Parts
1
2
and so on. Seems like a simple one but when I make the form control source a query using the DISTINCT keyword on Supplier column, I get is
Supplier 'A'
Parts
-----
-----
-----
Three blank rows which are actually the no. of distinct values. Any help on this will greatly appreciated.
Thanks.
I am new to VBA, I am trying to create a form that will take the DISTINCT values of a one column and then display all the records associated to that value in the form. I am not sure how clear was that, but this example will make it clear. I have this table with two columns Supplier and the PartNo.
Supplier PartNo
A 1
A 2
A 3
B 1
B 2
C 1
I want to create a form that will be like this (there is a tab between the alpabets and the numbers. due to some reason on posting they are very close to each other).
Supplier 'A'
Parts
1
2
3
The next record will be
Supplier 'B'
Parts
1
2
and so on. Seems like a simple one but when I make the form control source a query using the DISTINCT keyword on Supplier column, I get is
Supplier 'A'
Parts
-----
-----
-----
Three blank rows which are actually the no. of distinct values. Any help on this will greatly appreciated.
Thanks.
Comment