No Afterupdate event fires in unbound Combo

  • Thread starter Thread starter Lars Gustavsson
  • Start date Start date
L

Lars Gustavsson

I have an Access 97 form which have a navigation Combo on form. I
would like to use it as a quick selection tool for jumping to the
record I want. The Combo is unbound, and have no Control Source or Row
Source set. In Form Current event, I set the property, Combo.RowSource
= Me.Control & Me.Filter, whick seems to populate the Combo contents
in the right way I want anyway.

My problem is that I can't select any from the Combo because no
AfterUpdate Event fires. Not even the Click event will fire. The Combo
is unbound. The Combo drops down ok but I can't select any value from
it either.

I would appreciate if anyone could clarify why no event will fire.

TIA

/Lars
 
Lars Gustavsson said:
I have an Access 97 form which have a navigation Combo on form. I
would like to use it as a quick selection tool for jumping to the
record I want. The Combo is unbound, and have no Control Source or Row
Source set. In Form Current event, I set the property, Combo.RowSource
= Me.Control & Me.Filter, whick seems to populate the Combo contents
in the right way I want anyway.

My problem is that I can't select any from the Combo because no
AfterUpdate Event fires. Not even the Click event will fire. The Combo
is unbound. The Combo drops down ok but I can't select any value from
it either.

I would appreciate if anyone could clarify why no event will fire.
Click to expand...

If you can't select any value in the combo box, that probably means the
combo box is locked or the form doesn't allow edits. If you can't
change the value of the combo box, the AfterUpdate event will never
fire.

Does the form have its AllowEdits property set to No, by any chance?
Unfortunately, if that is so, even unbound controls cannot be updated.
You would need to set AllowEdits to Yes, but lock the controls you don't
want to allow the user to edit -- or else modify the form's recordsource
to make it nonupdatable.
 
Back
Top