Hi,
New to the forums and its been a while since i did any Access stuff but for the life of me i cant seem to find a solution , for what i believe is a simple issue.
I have an excel workbook that holds the value choice for the drop down box and what i would like it to do is populate 2 other fields in the table based on the selection made.
Workbook - 3 columns - Account number, Company Name, Postcode
(this workbook is static information)
Table - Account Code (drop down box) - Company Name - Postcode
Account Number is the drop-down and i'd like it to populate the corresponding Company/Postcode with the values from the columns next to it in the excel worksheet.
Thanks in advance,
o/
New to the forums and its been a while since i did any Access stuff but for the life of me i cant seem to find a solution , for what i believe is a simple issue.
I have an excel workbook that holds the value choice for the drop down box and what i would like it to do is populate 2 other fields in the table based on the selection made.
Workbook - 3 columns - Account number, Company Name, Postcode
(this workbook is static information)
Table - Account Code (drop down box) - Company Name - Postcode
Account Number is the drop-down and i'd like it to populate the corresponding Company/Postcode with the values from the columns next to it in the excel worksheet.
Thanks in advance,
o/