Just curious to know if it is possible to recognize which field(s) of a bound single form is going to be updated, prior to moving to the next record.
A user opens a form, Edits a field(textbox,combo box, checkbox etc) and moves to the next record. In before update event of the form is it possible to recognize which field(s) has been edited?
I know that I can:
What other options do I have?
FE is Microsoft Access & BE is SQL server.
Thanks for sharing your thoughts....
A user opens a form, Edits a field(textbox,combo box, checkbox etc) and moves to the next record. In before update event of the form is it possible to recognize which field(s) has been edited?
I know that I can:
- Use before update event of the objects in a form. I don't want to use this because a user may update the value of a field, but change his mind and undo the changes before moving to the next record.
- Use On-current event to save the current value of the fields to a set of variables or a temp table, then before updating the record, check the current values with previous ones.
What other options do I have?
FE is Microsoft Access & BE is SQL server.
Thanks for sharing your thoughts....