I have a Form that is showing a Table in Datasheet View that has 10 Fields. The 1st field is a Combo box. When a value is selected from this Combo Box, I default the remaining 9 fields to values related to the Combo Box Value using the "After Update" Event. This seems to work perfectly. This combo Box lists 1000 values, but there are 3 or 4 that are "Normal Selections". I have 4 buttons on my form so the user can automatically select a particular Combo Box Value from the List. When the button is pressed I set the [FieldName].Value = ButtonPressedValue. The Combo box field on the Datasheet reflects the new value, but the "After Update" Event does not fire off...as I have forced the value in and the Combo Box doesn't know it.
My question is - From my buttons, how do I trigger the Combo Box "After Update" Event after setting the Value?
I know in other languages there is a Combo Box Method that is used to "SelectRow(Index)" and then the Combo Box can't Tell if the user did it or some other fuction did it...but I don't see this in Access.
Thanks,
Ken
My question is - From my buttons, how do I trigger the Combo Box "After Update" Event after setting the Value?
I know in other languages there is a Combo Box Method that is used to "SelectRow(Index)" and then the Combo Box can't Tell if the user did it or some other fuction did it...but I don't see this in Access.
Thanks,
Ken