Form Design Challenge

[Mike in Arizona]

Ok, here's my problem. I've developed a form that populates an Access
table. I've figured out how to do pretty much everything with one exception.
I want the form to display information (fields) based on the selection made
in another control. I have the control set up as a drop-down list box with
the appropriate values/options being displayed. One thing I can't figure out
is how to pull in the data from the other fields from the same Access
database table.

Any ideas?

 

[S.Y.M. Wong-A-Ton]

Your question is not very clear to me.

You said that your form populates an Access table? Did you mean that a
repeating table on your form is filled with data from an Access table?

What do you mean with "pull in the data from the other fields from the same
Access database table"?

This weekend I will be posting (on my website) an example of how you can
populate a repeating section with data from an Access table by selecting a
record from a dropdown list box that is bound to that same table. I'm not
sure if this is what you are trying to do.

S.Y.M. Wong-A-Ton

 

[S.Y.M. Wong-A-Ton]

I've posted a simple solution for selecting and displaying information of a
record in an Access database table by selecting an item in a dropdown list
box that is tied to the same Access table, here:
http://enterprise-solutions.swits.net/infopath/dropdown-table-record-selection.htm

S.Y.M. Wong-A-Ton