Autopopulate field & list boxes based on form input

[BJ]

I am used to creating forms in Access and am able to create forms whose
fields and list boxes change based on other inputs on the form and queries
using these inputs. Is it possible to do this same thing with Infopath. For
example, if I have a list box with 5 choices. I want the choices in the next
list box to be the results of a query that includes the criteria of the first
list box. Any thoughts on how to do this?

 

[Renee in Juneau]

Two choices come to mind here.

The first would be to add some code via the "On After Change" event
handler. This might be the most intuitive path for you at this point.

To get to the code window for this, rightclick and go into the listbox
properties. Click on the "Data Validation" button. In the "Script"
area at the bottom of the dialog, choose "OnAfterChange" from the
dropdown and then click on the "Edit" button.

This can also be done without code but the explanation is considerably
more difficult. It will require a different way of looking at the
problem than you're used to but will pay off as you continue to use
Infopath - check out this page on creating cascading listboxes:
http://office.microsoft.com/en-us/assistance/HA011177131033.aspx

And I know I've also seen at least one infopath webcast that addresses
this technique. There were a whole series of infopath webcasts last
fall that are available on-demand via msevents.com - recommend you
check them out.

 

[BJ]

This is perfect...Thanks!!!

Two choices come to mind here.

The first would be to add some code via the "On After Change" event
handler. This might be the most intuitive path for you at this point.

To get to the code window for this, rightclick and go into the listbox
properties. Click on the "Data Validation" button. In the "Script"
area at the bottom of the dialog, choose "OnAfterChange" from the
dropdown and then click on the "Edit" button.

This can also be done without code but the explanation is considerably
more difficult. It will require a different way of looking at the
problem than you're used to but will pay off as you continue to use
Infopath - check out this page on creating cascading listboxes:
http://office.microsoft.com/en-us/assistance/HA011177131033.aspx

And I know I've also seen at least one infopath webcast that addresses
this technique. There were a whole series of infopath webcasts last
fall that are available on-demand via msevents.com - recommend you
check them out.