A releasable connection mechanism for use downhole with a tubular member includes a collet, a collet stop, and a ring housing. The collet is configured to engage the tubular member, the collet stop is axially movable with respect to the collet between a disengaged position to not engage the collet and an engaged position to engage the collet, and the ring housing is selectively axially movable with respect to the collet. In the disengaged position, the collet is configured to move with respect to the ring housing to engage the ring housing and prevent the collet from disengaging the tubular member when the collet is tensioned with respect to the tubular member. In the engaged position, the collet is configured to remain axially stationary with respect to the ring housing and disengage the tubular member when the collet is tensioned with respect to the tubular member.