Thank you.
The Equity code for the stock exchanges is different than the equity code that Yahoo uses.
Example; Toronto the code is ABC Yahoo wants the code as ABC-TO
So the code will be copied and than adjusted
Nicole
Thank you for your suggestion and we tried to continue the copy of the stock symbol to a third field without success.
===
Private Sub Symbol_Stock_AfterUpdate()
' copy FROM = Symbol_Stock = to = Symbol_Stock_Y
Me.Symbol_Stock_Y = Me.Symbol_Stock
' copy FROM = Symbol_Stock = to = Symbol_A
Me.Symbol_Stock_Y = Me.Symbol_Stock
End Sub
===
Could you please let us know what I have done wrong?
Thank you,
Nicole
What does "without success" mean - error message, wrong result, nothing happens? Perhaps need to change last line to reference Symbol_A instead of Symbol_Stock_Y.
Again, why save to table instead of calculating in query when needed?
Private Sub Symbol_Stock_AfterUpdate()
' copy = TO = Symbol_Stock_Y = FROM = Me.Symbol_Stock
Me.Symbol_Stock_Y = Me.Symbol_Stock
' copy = TO = Symbol_A = FROM = Me.Symbol_Stock
Me.Symbol_A = Me.Symbol_Stock
End Sub