In most cases, the Court requires specific paperwork be completed and filed before it will consider you as no longer being represented by your current attorney.
The name of the form may vary from state to state, but your attorney should know what is needed.
As such, notify your attorney that you no longer wish him or her to represent you. If you have retained a new attorney, provide that attorney's information to your existing attorney (it will be needed on the form).
(If you intend to represent yourself, then let your attorney know that.)
Your attorney will then prepare the necessary form (Notice of Substitution) for the appropriate signatures. Once the form has been signed and filed with the Court, you can proceed to represent yourself (or your new attorney may act on your behalf).
Note: Be sure you ask for and receive a court-filed copy of the document. If it is executed, but not filed with Court, nothing will change as far as the Court is concerned.
Good luck.