I have been searching and searching for the answer. Maybe it's the lingo I'm
using? I'd like to select a name in the drop-down list and once it is
selected it will populate the address, city, and state, etc. of that person,
company, or whatever. How do I create the dropdown list to perform that
function? Please help!!! Thank you!
If you're trying to pull the address, city, state, etc. from one table and
store it in a different table... DON'T. Storing data redundantly is
essentially never a good idea.
If your Form is based on the table containing this information, you can create
a combo box to *find* and display the desired record (including all these
fields). Turn on the "magic wand" icon in the form design toolbox, and create
a new Combo Box; choose the option "use this combo to find a record".
If your form's table is different than the table containing the address, etc.
but you just want to *display* that information, include all of the fields
that you want to see in the Query upon which the combo box is based. Make sure
that the combo's ColumnCount is large enough to include all these fields; you
can set the ColumnWidths property with zero width for these fields so they
don't appear in the dropdown. Then put textboxes on the form with control
sources like
=comboboxname.Column(n)
where n is the *zero based* position of the field in the query - that is, if
the phone number is the sixth field in the Rowsource query, use Column(5).
John W. Vinson [MVP]
