Exporting combo boxes to excel

[Graham63]

Hi Exprort Experts!

I have a subform with a combo box selection field among other fields. Can I export the data showing on the subform together with the drop down combo box data for each record and all its choices so that it appears as the same combo box on the worksheet. The user will then update combo box selections as required and the results would be imported back into access in the correct boxes for inclusion in a report, is that easily achievable for a moderate access user?

Thankyou

 

[TimW]

Hi
the question i have to ask (being asked for function like this all the time) is why does the information have to be exported? The users should have access to the database!!
If I have this correct - the drop down choices need to be editable - create a form to add these