From: Peter Stone on 24 Apr 2010 14:11
Access 2003, XP pro, semi-novice
I have a table "Expression" where records are similar to the one below:
[Adjective] & " " & [vehicle] & " is " & [color]
[Adjective] & " " & [color] & " " & [vehicle] & " has a puncture"
[Adjective] & " " & [vehicle] & " has a " & [color] & " stripe"
I have another table "Word" similar to that below:
I list the expressions in a list box. The AfterUpdate event of the list box
puts an = sign in front of the selected expresssion and makes it the control
source of a textbox.
By selecting records from table "Word" by combo box and displaying the
fields in hidden text boxes, I can view the following in the textbox:
My car is blue
His red bicycle has a puncture
Your truck has a green stripe
How can I also view the results of all the expressions in a listbox? I've
made several attempts but I don't know how to do it.
My actual expressions are quite different from this:
longer, more complicated, and more varied. I made up this example to keep it