Auto multi-level position numbering!!!!

[joe55555]

hello i have a big access prog and i need in a certain form to show multi level positioning for each record as the format 1.x.x


what i am looking for is like the following:




position field 2 field 3 field3
1 data data data ...
1.1 data data data ...
1.1.1 data data data ...
1.1.2 data data data ...
1.2 data data data ...
1.2.1 data data data ...
2 data data data ...
2.1 data data data ...
2.2 data data data ...
2.2.1 data data data ...

anyone has an idea of how to do that?

[June7]

How would Access 'know' to 'increment' the value and when to change to next number sequence? This would require a lot of code, if it's even possible.

Bing: Access treeview

http://support.microsoft.com/kb/209891

[joe55555]

This is a tree view, it is not similar to what i am trying to do, anyway thank you

[June7]

Treeview was the only thing I could find that comes close to what you describe.

I also searched on: VBA hierarchical numbering
Most everything returned was Excel related.

[joe55555]

Thank you