>I have a modeless form which I need to change to
>modal when the user goes to add a record.

Just a thought if it is impossible to MODE <-> MODELESS.

What about saving the form as a class and then
just recalling it in the different mode. Don't use private
datasessions and don't close the tables on exit
from one form to another.