I am working on a macro whereby the user enters a search term which is used to query an Access Database. My question is how do I return those records to Excel in separate rows?

For example, a database contains home address information. If the user searches for a zip code, the records that are selected would go into row 1, 2, 3, etc. for as many records as are returned in the query.

Below is some example code - the part I am missing is clearly marked.

I appreciate any help!

Please Login or Register  to view this content.