A
AC
Hi
I would like to run some code in a module (or perhaps another form)
which:
1. opens another form
2. populates a combo box with a particular value that I want
3. runs the after update event for that combo box.
I have the following code which does steps 1 and 2 OK:
stFormName = "f_combo"
DoCmd.OpenForm stFormName, , , stLinkCriteria
Forms(stDocName).Controls("Combo3").Value = "Hello"
I need to know how to do step (3)
Out of interest, what triggers an after update event? I naively
expected my code above to trigger it automatically when I updated the
value to "hello".
When you answer, could you also indicate if I need to make my after
update event on Combo3 public, or can it remain "private" and still
work.
Thanks in advance
Andy C
I would like to run some code in a module (or perhaps another form)
which:
1. opens another form
2. populates a combo box with a particular value that I want
3. runs the after update event for that combo box.
I have the following code which does steps 1 and 2 OK:
stFormName = "f_combo"
DoCmd.OpenForm stFormName, , , stLinkCriteria
Forms(stDocName).Controls("Combo3").Value = "Hello"
I need to know how to do step (3)
Out of interest, what triggers an after update event? I naively
expected my code above to trigger it automatically when I updated the
value to "hello".
When you answer, could you also indicate if I need to make my after
update event on Combo3 public, or can it remain "private" and still
work.
Thanks in advance
Andy C