I have a Form and a Subform. The form has a field called "Lesson Name" The subform has a Como box that looks up a Learning Objective from a table. The Objectives are partial sentenances with a | Pipe inserted as a marker. When I select a value from the Combo box I want to use its value concantinated with the Lesson Name value. I have built the concantination and it works perfectly.
I need to set a value on the subform (Learning Objective) to the result of the concantination. I have set the VB to trigger on the Combo Box After Update event to:
This works the first time through but crashes if I make select another item from the dropdown menu.
Help please.
I need to set a value on the subform (Learning Objective) to the result of the concantination. I have set the VB to trigger on the Combo Box After Update event to:
Code:
.Value = (Left([LODD], (InStr([LODD], "|") - 1)) & " " & Forms![Lesson Creation Form]![Lesson Name] & "" & Mid([LODD], InStr([LODD], "|") + 1, 50))]This works the first time through but crashes if I make select another item from the dropdown menu.
Help please.
