Windows 7 64bit 
Access 2010 64bit
What I am trying to do is populate the specific fields on excel sheet based on access query. so say I have 3 separate fields Name, Job, Salary on excel sheet (already designed excel sheet). and my access query has all 3 fields pulled up for all employees. Now if a person selects his "Name" on access form person should be able to see prepopulated excel sheet with his name, job and salary. I know I have to go recordset path. But I have never done this before. Please guide with step by step what should I do and make it possible.
Reply With Quote
