V
Van T. Dinh
It sounds to me that you expect the Form_BeforeUpdate
Event behaves the same as the Control_BeforeUpdate Event.
They are different. The 2 procedures have different
purposes.
For bound Form, the Form has a Record buffer which is more
or less the temporary storage area for the Record being
edited.
The Control_BeforeUpdate Event occurs just before the
*Record buffer* is updated with the new value in the
TextBox Control. This happens on most editable Controls
on the Form.
The Form_BeforeUpdate Event *only* happens just before the
Table(s) is/are updated with the data in the Record buffer
of the Form.
Thus, the Form_BeforeUpdate Event procedure only occurs
when you actually save the Record into the Table(s), i.e.
when you move to another Record or close the Form or force
the saving of the Record using the Menu or VBA code.
Your Control_BeforeUpdate procedure is actually misleading
because you are not saving anything yet!
HTH
Van T. Dinh
MVP (Access)
label. Nothing seems to happen if I do the following:
Event behaves the same as the Control_BeforeUpdate Event.
They are different. The 2 procedures have different
purposes.
For bound Form, the Form has a Record buffer which is more
or less the temporary storage area for the Record being
edited.
The Control_BeforeUpdate Event occurs just before the
*Record buffer* is updated with the new value in the
TextBox Control. This happens on most editable Controls
on the Form.
The Form_BeforeUpdate Event *only* happens just before the
Table(s) is/are updated with the data in the Record buffer
of the Form.
Thus, the Form_BeforeUpdate Event procedure only occurs
when you actually save the Record into the Table(s), i.e.
when you move to another Record or close the Form or force
the saving of the Record using the Menu or VBA code.
Your Control_BeforeUpdate procedure is actually misleading
because you are not saving anything yet!
HTH
Van T. Dinh
MVP (Access)
unfortunately, it only seems to work if I code each text
label. Nothing seems to happen if I do the following: