Automatic population of a field in an input form

[Guest]

I have been away from Access for a few years, so I am struggling with a
problem which I'm sure is an easy fix. I am working with Access 2003, and my
form has a field for a Customer ID number. When that number is put into the
Customer ID field, the Customer Name is supposed to automatically populate
the Customer Name field as soon as I tab into that field. I am working off
of one table to accomplish this. Is this accomplished with the criteria
section of a query, and if so, how? If now, can someone please walk me
through the steps to accomplish this.

 

[Al Campagna]

OwlLover,
If I understand correctly... you have a table will all your current
customer information, including CustomerID and CustomerName.
Then, on another form... (like an Order Form or Invoice Form), you
select various customers for various jobs/sales etc... etc...

The method I prefer to select a Customer ID is a combo box (ex.
cboCustomerID)
That combo would have two colums... CustomerID and CustomerName, in that
order... and cboCustomerID should be bound to the CustomerID field of your
table.

Set up the combo properties as follows... sorted by CustomerName.
NoOfColumns = 2
ColumnWidths = 0"; 2" (Notice the 0" first colum)
LimitToList = Yes
Width = 2"

What this setup will do... "display" just the CustomerName for the user
to easily select... BUT... when a CustomerName selection is made, the
CustomerID field is really what gets stored in the bound CustomerID field,
and... after selection the CustomerName remains displayed in the combo.
In the case you laid out, that's all you need.
The CustomerName is displayed in the combo, but we're really capturing
the CustomerID.. which is all you should be storing to properly identify
that specific customer.
--
hth
Al Campagna
Access MVP 2007
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love, and you'll never work a day in your life."