I am new to Access forms/VBA. In the form I need to populate text boxes based on the number of lines for a particular record.
For ex:
I have the records in the format:
AAA 1 ABCD
AAA 2 BCDE
AAA 3 RESQV
BBB 1 WQSA
BBB 2 REFD
BBB 3 GFDDF
BBB 4 YTRHYTR

in the form, it has to list like this:

AAA 1 ABCD
2 BCDE
...