Prev: Trouble Creating Tables
Next: Show N/A like default in combo box
From: Tegan on 15 Feb 2007 16:32
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
From: Cheese_whiz on 15 Feb 2007 17:18
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

"Tegan" wrote:

> 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
 | 
Pages: 1
Prev: Trouble Creating Tables
Next: Show N/A like default in combo box