There are a few tricks involved in horse archery, such as exactly when in the horses stride to let loose the arrow. You also need to learn to compensate for your own momentum when aiming. If a skilled archer was also a skilled rider, which is definitively not a given, then it is possible that with some retraining they could make a good horse archer. It is highly unlikely that a good archer could simply sit upon a horse and suddenly be capable though.