VBA Code in Access w/ option buttons

[WebKiid]

I have created 2 option buttons in Ms Access 2007, on a blank form. The scenario is: I have a database with different events, and each event has there own ID.. What i need to do is when i click one option button and hit a command button, it then exports that file into excel based on the eventID from the option button that i selected.



Can anyone give me a hand on this?

Its really important, that i get this answered. Its for my job.

[RuralGuy]

Have you worked out how to export a table to Excel yet?