hi
if all you are doing is adding records, it would be far, far easier to enter
the data in access directly. reason is that the input form and the data would
be contained in the same database. excel and access do work well togeather
but for input, i think it would be better to use access as input then use
excel to extract reports via microsoft query.
on the menu bar....
toolsimport external datanew database query

my thoughts
Regards
FSt1

"Pam W." wrote:

First, I want to say how valuable this website is. I've gotten so much help
finding information from other posts.

I've used all this valuable information to create macros that have dazzled
my boss. Now, I'm afraid they think I can do anything. LOL. Let me know if
I'm in over my head--or how far over my head. (I am not familiar with
Access) They want to have an Access database and be able to query data using
Excel. Then they want to pull certain fields from one of the records chosen
by the user into an Excel worksheet. Once it's in this worksheet, it will
have other data added to various column. Then they want to be able to save
that record as a new record in the Access database.