What is the impact on currency when there is foreign investment?

In my opinion when there is foreign investment, there will be more demand on the country which is invested. Therefore, its currency is appreciated. Besides, that would help to boost the economy, so the currency will go up.