Output on Excel Spreadsheet using a Query Based Form

M

Mr. X-Access

I have a Query Based Form. On the lower half of the form I have added an
Excel spreadsheet. I would like the cells of that spreadsheet to show the
output of the query.

Example:

If I enter Name using the list box in the form, The lower half of the form
which is a spreadsheet shows financial data about that person (Stocks,
prices, historical prices..). The idea of using a spreadsheet is to allow the
person to perfomr calculations on his/her financial portfolio.

The Query Based Form runs its query on an Access 2000 Database. This whole
form is designed in Access 2000.

Please assist!

Thanks
 
Top