VBA Coding in Access XP

  • Thread starter Barrie Finch - Internet Builders Limited
  • Start date
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top