Re: Auto Fill II (for Access 2002)
- From: John W. Vinson <jvinson@xxxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Tue, 30 Dec 2008 18:38:48 -0700
On Tue, 30 Dec 2008 13:40:28 -0800, Brendan
<Brendan@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:
My questions is similar to the earlier question titled Auto Fill. I am
creating a form and would like to know if it is possible to have the text
boxes on the form auto fill. What I would like to be able to do is choose a
customers name from a combo box and have the information that is tied to that
name in several different tables populate text boxes within the same form.
The combo box is pulling information from a table titled "customers" wich
would be the table that would provide most of the information for the form,
but three other tables would have information that would need to be drawn out
as well.
Please Help!
Thanks so much,
Brendan
If you're trying to copy information from a customers table into some other
table... DON'T!!!
Access databases use the "Grandmother's Pantry Principle" - "A place - ONE
place! - for everything, everything in its place". The customer information
should exist *only* in the Customer table; all you need in (say) an Orders
table is the unique CustomerID.
If you just want to *show* the information on the form, without storing it,
you can put all the fields that you want to see in the combo box's Row Source
query. Display them on the form by putting textboxes on the form with control
sources like
=comboboxname.Column(n)
where n is the *zero based* index of the desired field (e.g. if the customer's
phone number is in the fifth column in the query use Column(4) ).
--
John W. Vinson [MVP]
.
- References:
- Auto Fill II (for Access 2002)
- From: Brendan
- Auto Fill II (for Access 2002)
- Prev by Date: Re: Auto Fill II (for Access 2002)
- Next by Date: Re: purpose of subform?
- Previous by thread: Re: Auto Fill II (for Access 2002)
- Next by thread: 2000 - 2003 - 2007 References in Vista - I'm going crazy!
- Index(es):
Relevant Pages
|
