Form Design Challenge

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Mike in Arizona - 11 Jan 2006 03:25 GMT

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?

Reply to this Message

S.Y.M. Wong-A-Ton - 12 Jan 2006 08:24 GMT

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

> 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.
[quoted text clipped - 5 lines]
>
> Any ideas?

Reply to this Message

S.Y.M. Wong-A-Ton - 13 Jan 2006 09:56 GMT

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

> 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.
[quoted text clipped - 5 lines]
>
> Any ideas?

Reply to this Message