Retrieving Data from an Access Database

[Underground]

I created a form to retrieve vendor information from a database, address,
phone, fax ect. In the form I have a drop list where one selects the vendor
name then I want the address, phonenumber, fax, ect to be filled in
automatically. The drop down list works, it displays all the vendors
information but the rest of the fields default to the information of the
first vendor in the list. Always the same information how can I get the right
information out of the database.

 

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

I'm not sure how you have your form set up, but a "recipe" (=solution) I
posted not too long ago should give you an idea of what you need to do. Check
out
http://enterprise-solutions.swits.net/infopath/dropdown-table-record-selection.htm

If you haven't "tied" your database to the main data source, you could
create rules on the dropdown to set the values of the fields. The way you
would do this is use the identifier of the selected vendor from the drop down
list box to lookup information in a secondary data source and set the value
of the fields containing vendor information to the corresponding value found
in the secondary data source but then filtered on the selected vendor
identifier.