Hey, I have an Access database.

What I want to do is create a default spreadsheet design that can load information from a selected record in my database and put the information in the right places.

This is for invoice purposes.
So, for instance if I wanted to create an invoice for Customer 3, I'd select their record in Access and then click something that would load their information into the pre-made spreadsheet I designed so I could print it out.

Is this possible, and if so, how?
Would I need to create the spreadsheet in Excel first?

Is there a way to add a dropdown menu in a box in Excel full of values from a field in the Access file and have it load the Access values for that record in various cells based on that?

___________________
www.misterfalconmusic.com