Automatically populating month fields

[Janie]

I created a table with 12 columns. The header row for each column will
contain mnoths of the year. If a user types in "March" in the first column,
I want the rest of the column headers to automatically populate with the
following 11 months. Any ideas?

[Alex [MSFT]]

Create an XML file with a list of months:
<calendar>
<month>
<name>January</name>
<number>1</number>
</month>
...
</calendar>

Plug it into your form using Tools | Data Connections | Add.

Then use rules or default values to set the values in each column.

Let me know if you need more help.

-Alex

"Janie" <Ja...@discussions.microsoft.com> wrote in message
news:8C47EDF9-A5F6-4DE6...@microsoft.com...