Auto Fill from Access Database

[Neil]

New to Infopath and really need help. I have data coming from a local Access
database. I want to type in a serial number of a piece of industrial
equipment in an infopath form and have it autofill all corresponding data
from the database (relating to this piece of equipment) into this form
filling out all of the other fields for me.

Any SIMPLE way to do this ?

Thank you !

 

[Adam Harding]

Neil

Essentially very simple

1)you make the serial number text box a queryfield and put a button on the
form to search. make the rest of the forms fields datafields from the
database and Bob is your uncle.

or 2)You could make it more automatic and remove the button and set each
other field to display the information it is meant to be displaying where
(using filter) the serial number equals the serial number at the top of the
form from your access database. Ask me for help at
(e-mail address removed)

I would recommend 1) to get used to it and then after you have got it
working start working on 2).

Cheers Adam

 

[Neil]

Sorry to sound stupid buthow do you change a text box to a query field and
can you also help me set up the button ?. I have a button on my form now but
dont know how to program the button. Im new to this and really want to get
this form working. Thanks a bunch for your help. Cheers !