Possibly use a parameter query with a query table:

http://nickhodge.co.uk/gui/datamenu/...taexamples.htm

You can trigger an update using the change event for the worksheet.

--
Regards,
Tom Ogilvy

"Squiggy56" wrote in message
...
I am setting up a database using access to form a client contact list, I
also
have an in depth form in excell which is used for a client assessment.
How
do set the database up to prepopulate the name, address, and contact
details
using ID to my excell sheet, and to be able to move between sheets back
and
forth?