Afterupdate only works on first combo

J

Julian Stevens

I'm trying to create a continuos form with 3 combo boxes in such a way
that if any combo has its value changed, the bound table is
immediately updated. I want to be able to change any of the combos
any number of times, without changing record, and have the table
update each time.
I've tried using
DoCmd.RunCommand acCmdSaveRecord
in both the AfterUpdate and GotFocus event procedures of all three
combo boxes, but it only seems to work when I change the 1st combo
box, even though all three have identical code!
Please can anyone suggest a solution to this.

Thanks,
Julian
 
Top