Chris W writes:

In this situation the bicycle is obviously not moving forward. How does
it stay upright?

The cyclist balances it, assisted by the gyroscopic stabilizing effect
of the turning wheel (the heavier it is and the faster it turns, the
better).

--
Transpose mxsmanic and gmail to reach me by e-mail.