Fill form based on combo box

[goeppngr via AccessMonster.com]

I have searched the system and can't quite find something that will do what I
want.

I have a table, tblSettings that has about 35 fields. One of the fields
contains a description for a specific part in our manufacturing facility
(DIEDES). I am wanting to create a form with a combo box (selections based
on the DIEDES), that when selected will populate the other 34 textboxes with
the data in the table that corresponds with the users combo box selection.
Currently the form has its' recordsource as tblSettings, with the combo box
unbound, but I don't feel this is correct way to proceed. How can I quickly
populate those textboxes based on the selection from the combo box?

As an added convenience, I would like for the default form to be blank. Any
help is greatly appreciated.

 

[Al Campagna]

Go,
On my website (below) I have a sample file (A97 or A2003) called
ComboPopulatesMultipleFields. It demonstrates how to select an item from a combo, and
display ancillary info about that selection derived from columns in that same combo box.
That will show you how to "display" multiple pieces of information from one combo
selection.
Please look that sample file over to understand that particular technique.

When multiple transactions occur against an established "part" from a Parts table, it
is not necessary... nor good design to capture other associated values regarding that
particular part. All you need to capture is the unique key value for that part... say
PartNo.
Maybe you'd like the user to "see" the PartDescription as well as the captured PartNo.

The concept is that in any subsequent form, report, or query... given that you
captured the PartNo, you can always use that value to relate back to your Parts table,
and... all it's associated ancillary data.
--
hth
Al Campagna . Candia Computer Consulting . Candia, NH USA
Microsoft Access MVP
http://home.comcast.net/~cccsolutions

"Find a job that you love, and you'll never work a day in your life."