G
Guest
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.
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.