Hi folks,
Does any one know a way to automatically populate a cell in access with info
from a database based on a value entered in another cell?

For example I would like have a column "Part Number'' and when someone
enters a part number in one of that columns cells, the database table,
tblPART is queried to return the description where PART_ID = the part number
in the first cell and places the value into an adjacent cell. In my case
PART_ID is the primary key for tblPART so I will only get the one value that
I want.

In access i would do something like this with a dlookup statement, but i
have no idea where to begin with excel!

Thank you in advance for your help!
M.

Hi M,

I don't know about Access and dlookup, but it sounds like VLOOKUP() in Excel,
like in

=VLOOKUP(A1,Sheet1!A1:B7,2)
( =VLOOKUP(LookupValue,LookupRange,Column,Exact))

or to hide the error when the lookup cell is empty
=IF(A2="","",VLOOKUP(A2,Sheet1!A2:B8,2))

Use the Insert Function Wizard and refer to Excel Help for details.

HTH
Anders Silven

<M.Streeks skrev i meddelandet ...
Hi folks,
Does any one know a way to automatically populate a cell in access with info
from a database based on a value entered in another cell?

For example I would like have a column "Part Number'' and when someone
enters a part number in one of that columns cells, the database table,
tblPART is queried to return the description where PART_ID = the part number
in the first cell and places the value into an adjacent cell. In my case
PART_ID is the primary key for tblPART so I will only get the one value that
I want.

In access i would do something like this with a dlookup statement, but i
have no idea where to begin with excel!

Thank you in advance for your help!
M.