Ms access Vba Save Data to xl depends upon 1 table pick & Depends 2 Upon fiterDate

Dear Experts

I need vba help on Msaccess form Cmd button retrive data from Start & End date depends upon of Tabular column

I have set of 3 Table column named Dispatch,Closed,Cancel & One Form

condition is
If Select Dispatchcalls Filter Date col is = "Order Relase Date". Col No 26
If Select ClosedCalls Fitler Date Col is = "ClosedDate". Col No 48
If Select Cancelcalls Filter Date Col is = "ClosedDate". Col No 38

Save
1.If DispatchCalls select in table List and Filter Date in Start&End ..Retrive Data from Table DispatchCalls depends upon OrderrelaseDatecol... Savefile as Dispatch
2.If ClosedCalls select in table List and Filter Date in Start&End ..Retrive Data from Table ClosedCalls depends upon ClosedDatecol... Savefile as Closed 3.If CancelCalls select in table List and Filter Date in Start&End ..Retrive Data from Table CancelCalls depends upon ClosedDatecol...savefile as Cancel

Find the attachment


Refer this code
http://www.excelforum.com/access-pro...eted-file.html