Unanswered question

[DaveB]

Can I do a combo box so that when I start typing text in
one field, it will choose multiple fields from a
different table and complete all of the other fields in
original table also? What are the steps to do this?
..

 

[Ken Snell]

Your question is not clear. Can you rephrase it with more details about
exactly what you're wanting to do? And perhaps give an example?

 

[DaveB]

Sure, no problem. I've only been learning access for
about a week now, so I don't know how do anything
basically. What I'd like to do is this. I have a table
with Phone prefix's, cities, Counties, Zip Codes, and The
Thomas Guide Page. I'm a plumber starting a new business.
So what I'd like to do is when I type in the prefix it
will look up the rest of the information that I've stored
in that table, and fill it in my form.

Is that any clearer? I hope that you can understand me
now.

Please feel free to e-mail me. I will leave it this
time.

 

[John Vinson]

Can I do a combo box so that when I start typing text in
one field, it will choose multiple fields from a
different table and complete all of the other fields in
original table also? What are the steps to do this?
.

"choose" multiple fields? "complete all the other fields in the
original table"?

I'm sorry, it's not clear what you're trying to do. Are you trying to
use the combo box to select a record in one table and copy the entire
record into another table? If so, why? Storing data redundantly is
almost always a bad idea.

Step back a bit and describe *why* you want to do this, and what
real-life problem you're trying to solve; I suspect there is a better
way.

 

[Van T. Dinh]

Look at the first ComboBox in the "Orders" Form of the sample database
"NorthWind" that comes with your Access software. This ComboBox actually
shows how to "fill" 2 different sets of TextBoxes (calculated TextBoxes and
bound TextBoxes).

 

[Kevin]

I'm a plumber starting a new business.

So what I'd like to do is when I type in the prefix it
will look up the rest of the information that I've stored
in that table, and fill it in my form.

What Dave suggests will work, but I agree with John Vinson-
-since the data can be retrieved and displayed on a form
via a query, there's no need to store it in your address
table. Duplication is both a storage and data integrity
issue.

HTH
Kevin Sprinkel
Becker & Frondorf