Automatically populating month fields

J

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?
 
A

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top