Complete Idiot Here... Help

[Ted Clore]

I am new to Access.

I have imported an Excel Spreadsheet. It has my Customer information... Customer ID, Customer, Address, City, etc.

How do I make it show when I enter the Customer ID into a field, that it will fill in other fields without having to manually fill in the fields.

For instance:

Customer ID , I enter the ID and it will fill in:

Customer
Address
City, State Zip


Thank you.
Ted

 

[Rick B]

I would recommend that you go look at the Northwind database that ships with Access. The "orders" form (I think) has a similar reflex to what you are asking for.



--
Rick B



I am new to Access.

I have imported an Excel Spreadsheet. It has my Customer information... Customer ID, Customer, Address, City, etc.

How do I make it show when I enter the Customer ID into a field, that it will fill in other fields without having to manually fill in the fields.

For instance:

Customer ID , I enter the ID and it will fill in:

Customer
Address
City, State Zip


Thank you.
Ted

 

[Duane Hookom]

Rick is correct about the form/subform in Northwind.

I assume you have a good justification for storing the same information
multiple times in your tables. The Order form in Northwind needed to store
the unit price of a product in the Order Details since the unit price will
change over time (consider recent gasoline prices).

The method that I recommend is a combo box named "cboCustID" to select the
CustomerID with a row source like:
SELECT CustomerID, Customer, Address, City
FROM tblCustomers
ORDER BY Customer;

You can run code in the After Update event of the cboCustID combo box that
would place values from columns in the combo box to controls on your form:
Me.txtAddress = Me.cboCustID.Column(2)
Me.txtCity = Me.cboCustID.Column(3)

--
Duane Hookom
MS Access MVP
--

"Rick B" <Anonymous> wrote in message
I would recommend that you go look at the Northwind database that ships with
Access. The "orders" form (I think) has a similar reflex to what you are
asking for.



--
Rick B



I am new to Access.

I have imported an Excel Spreadsheet. It has my Customer information...
Customer ID, Customer, Address, City, etc.

How do I make it show when I enter the Customer ID into a field, that it
will fill in other fields without having to manually fill in the fields.

For instance:

Customer ID , I enter the ID and it will fill in:

Customer
Address
City, State Zip


Thank you.
Ted

 

[Ted Clore]

Thanks again,
Ted