hi Giorgio,
> "Show message history"
:) great! glad you see it ~
"You wouldn't need the table or Private Sub Combo46_AfterUpdate()?"
you need the table!!!! ... just not code to update a value that can be obtained anytime. Create a table with all the stock abbreviations and names (much better than putting that into code! as Duane pointed out) -- if you just store the symbol, you can look the name up anytime. If you know the name but not the symbol, you can have a combo box that shows the names on a list and stores the symbol when you pick it -- did you watch the combo box video? Do you see how to apply this to your situation?
What is a Combo Box?
https://www.youtube.com/watch?v=2y85oDWaSh0
crystal
How do you keep previous messages when you reply? Oh, I get it now: select "Show message history"
---In MS_Access_Professionals@yahoogroups.com, <strive4peace2008@...> wrote :
Access 2010, Windows 7I am adding case statements to after update of Unbound Combo Box. After first few VBA automatically keeps adding "Is" after the Case and it does not let me to delete them. See below, please help. Ken
Private Sub Combo46_AfterUpdate()
Select Case Me.Combo46
Case "American Eagle"
Me.Stock = "AEO"
Case "Broadcom Inc"
Me.Stock = "AVGO"
Case "XPERI CORPORATION"
Me.Stock = "XPER"
Case "Bank of America"
Me.Stock = "BAC"Case Is = "Nextra Energy"
Me.Stock = "NE"
Case Is = "Ocean PWR"
Me.Stock = "OPTT"
Case Is = "Rigel Pharmaceuticals"
Me.Stock = "RIGL"
Posted by: crystal 8 <strive4peace2008@yahoo.com>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (11) |
Tidak ada komentar:
Posting Komentar