Highlight the macro in the database window. Then, File/Save As. In the
dialogue box choose Save as Module. Give it a new name if you like. Decide
if you want error handling and comments and viola!
HTH, Mike MacSween
"TD" <td*********@midsouthfair.com> wrote in message
news:bd******************************@news.teranew s.com...
Can anyone tell me how to convert a macro to a module?