Need Access 2007 Help Please!!!

[Arty]

Hi!

I'm new to access and simple instructions would really benefit. Okay, so
here's the problem:

* I need to have a drop down box containing a Supplier ID that when the
numbers are selected in the form, the Supplier Name automatically fills in

*This is isn't record retrieval system, meaning it's only meant for ease of
data entry; since there is finite group of suppliers

What I have:

* I have the 2 fields in my table and in my formed named Supplier ID and
Supplier Name, respectively.

* The Supplier ID is combo button, so the drop-down menu is settled

What I don't have:

* I don't know which macro steps allows me to select Supplier ID, which
automatically fills in the Supplier Name

Can anyone help me?

 

[tina]

presumably you have a "master supplier list" table, correct? and you're
using that table (or a query or SQL statement based on that table) as the
*RowSource* of the combobox control in the form, correct?

so in your data table (that the form is bound to), you should not have a
SupplierName field, only a SupplierID field. i'm assuming that the supplier
ID value is *not* one that your user(s) should have to know, in order to
enter a supplier in a record. so in the data entry form, bind the combobox
control to the SupplierID field, but don't show the SupplierID column, only
the SupplierName column, in the droplist. you can do that by setting the
ColumnWidth property to

0"; 1"

the first column being SupplierID, and the second column SupplierName (you
can change the width from 1" to however wide you want it to be, of course).

the user can enter a supplier name in the combobox, but what is stored in
the field of the underlying table is the SupplierID, which links back to the
SupplierID value in the "master supplier list" table.

hth