access and excel linking invoice - help - detailed desc. inside

[roger89]

Ok, so I have an invoice table in MS Access, but I want the invoices made in Excel. The layout is done, but I'm having some troubles getting some data in. I would like to have a combo box with a list populated from ‘invoiceID’ in the Invoices table. When that is chosen it auto populates the cells with things like delivery date etc. I'm assuming I assign each invoiceID a list of strings (aka make each invoiceID an array of strings ( I don’t know how to do this either) and use those array elements to populate the table. Could someone point me in the right direction as to how i could accomplish this? Thanks!

in short:

i have invoices table

i have combo box in excel

i want combo box to have invoice id's

i choose invoice id's

then, invoice layout has for example due date, in the due date cell, i want the duedate field from the invoice table to be automatically be sorted when invoice id is chosen

once i know how to do 1, i can do it for all fields,

anyone willing to give me some of there time will be loved 4 life


THANKSSS XXX

 

[boblarson]

PLEASE STOP posting duplicate posts. If you make a mistake and post in the wrong forum, report it to the Admin by clicking on the exclamation mark in the red triangle.

 

[roger89]

i posted it in the excel and access forum as it applies to both and i really need to learn how to do this, sorry, any help appreciated still.

 

[boblarson]

It is poor forum ettiquette to post the same question more than once, even if they do apply to both. Pick the one you think it fits best, and remember that even though you really need it, we are all volunteers here so we help when we can or when we feel like it. We have a large contingent of people who post answers so it is highly likely you will get a fairly quick response, but it isn't guaranteed. But posting multiple times is just going to make those same responders irritated and so you may wind up with no responses by doing so. Just thought you should know. And I can't answer right now as I have to start work on a contract that I'm working on in my off-hours.

 

[roger89]

hi okay lesson learned, appreciate it, sorry, jsut wasn't sure if access people checked excel forms and vice versa, my bad.

anyone with time to help me learn it will be greatly appreciated, thanks again