C
cwilkins59 via AccessMonster.com
I have table:
WBS ReportDate Name Highlights
1.1.1 Week 1 Test This a memo
field
1.1.2 Week 1 WBS Name These are the
highlights
1.2.1 Week 1 Another name Text goes here
1.2.1.2 Week 2 Name more text
When a rollup number is created (ie 1.1) I want to be able to click a button
and the highlights field will populate with all highlight under that number.
So looking at the table above the 1.1 WBS would be populated with the
highlights for 1.1.1 and 1.1.2 and if 1.2 was created we could hit the
command button and the highlights from 1.2.1 and 1.2.1.2 would be populated
into the 1.2 highlights field.
So if we looked at 1.1 I need to create some code that looks for WBS values
between 1.1.1 and 1.1.9 and then concats the highlights field from those into
the field that is open when I click the command button.
I apprecaite your help!
WBS ReportDate Name Highlights
1.1.1 Week 1 Test This a memo
field
1.1.2 Week 1 WBS Name These are the
highlights
1.2.1 Week 1 Another name Text goes here
1.2.1.2 Week 2 Name more text
When a rollup number is created (ie 1.1) I want to be able to click a button
and the highlights field will populate with all highlight under that number.
So looking at the table above the 1.1 WBS would be populated with the
highlights for 1.1.1 and 1.1.2 and if 1.2 was created we could hit the
command button and the highlights from 1.2.1 and 1.2.1.2 would be populated
into the 1.2 highlights field.
So if we looked at 1.1 I need to create some code that looks for WBS values
between 1.1.1 and 1.1.9 and then concats the highlights field from those into
the field that is open when I click the command button.
I apprecaite your help!