Enter customer #, auto fill customer info?

[Guest]

Is there such a thing in MS Access 2003, that you have a form created, and
you have a field called "Customer Number", the primary key in the Customer
table, where when you fill that in, it automatically fills in the remainder
of the customers information such as telephone and e-mail so long you have it
somewhere in the table?
I have a form created with the fields: Entry Number (wishing it to be
Customer Number once I get this figured out...), Name, Number, E-mail, then a
sub form and in the perfect world, I would like to think that I don't have to
continue typing in the information over and over and having many different
sub forms for the one person, opposed to everything neatly being in one.
Ugh..I'm so confused, I've been working on this all day at work. Can anyone
please help me? If you need any additional information or me to clear
anything up a bit more, just say so. Thank you greatly!

Regards,


Tegan

 

[Guest]

You can use the combo box wizard to create a combo box on your form that
looks up the records based on your selection of an ID# in the combo box.

Use the toolBOX with the 'control wizards' selected to draw out the combo
box and then follow the wizard instructions.

CW