I've got an Access db that has thre

[Joshua61679]

I've got an Access db that has three steps to fill out. First there is a general form, then a service form, then a job specific form. These are called NewJob, Cased1, & Cased2 respectively. I need to use the information from these 3 forms to populate an Excel template that's a bid sheet named simplecasedhole.xls. All of the fields corrispond and are named accordingly on both the forms and the spredsheet. I only want information from the current record though. Basically, I'd like to use the Excel sheet like a report. Is there a way to do this?

 

[cmmrfrds]

You can link the excel spreadsheet into access as a linked table and then populate like any other access table.