B
Barrie Finch - Internet Builders Limited
Could anyone help me with a piece of VBA.
I am trying to find a way to call the name of the current focus on a form.
If for example you were in the group_name field then you could write a piece
of code that says "After Update set the value of field current_field_name to
the name of the field / text box (or current focus) that you are editing.
I am trying to track changes to each individual field and log them in a
table but cannot genetrate the current name of the field that has the focus.
I know I could write an OnEnter command but I would have to do this far each
field on the form and replicate the code every time which I really do not
want to do.
Any ideas would be appreciated.
Thanks in advance.
Barrie Finch
I am trying to find a way to call the name of the current focus on a form.
If for example you were in the group_name field then you could write a piece
of code that says "After Update set the value of field current_field_name to
the name of the field / text box (or current focus) that you are editing.
I am trying to track changes to each individual field and log them in a
table but cannot genetrate the current name of the field that has the focus.
I know I could write an OnEnter command but I would have to do this far each
field on the form and replicate the code every time which I really do not
want to do.
Any ideas would be appreciated.
Thanks in advance.
Barrie Finch