How write new value to a 2nd field using the first three parts of the 1st field
Posted on 2014-02-19
On a form I have a field that for example reads,
"Mountain Picture, 8x10, Matted, Vertical, New York"
Note that there will always be 4 character strings with commas following in every case.
Also on the form is a combobox named cboToLocation which shows column 2 from the underlying query (even though the ID field is in the first column and is bound to the field on the form. That field might display, for example, "Rockford".
In the after update event of the cboToLocation field I want a field named "New Product", to read "Mountain Picture, 8x10, Matted, Vertical, Rockford"
In other words replace "New York" with "Rockford" in the "New Product" field.
How do I code this?