Concatenated Control Not Updating

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a concatenated field containing values from four controls that is
filled when a user enters a value in the 4th combo box. The field consists of
a (1) ticket number, (2) date, (3) state name, and (4) problem description.
the date is autofilled, but users may need to change it -- and therefore the
concatenated values need to update if the date or any other values in the
concatenation are changed.

I was testing changes to the state name, and put a requery in the After
Update event of that control. But nothing happened. Can anyone suggest
events/code to use to get the concatenation to update? Many thanks.
 
Hi,
It's not clear to me how you are producing the concatenation, but it sounds like it
happens in the AfterUpdate of what you call the 4th combo. Just do it from the AfterUpdate
of the other controls as well.
 
Yes, I did have the code in the after update of combo 4. And yes, putting the
same code in all the other controls did the trick! Thanks so much!
 
Back
Top