I am trying to create a macro or VB code which refers to the current field
which is selected. Because I am trying to create a macro which will be able
to be used for different fields. So if I have Field1 and Field2 and I am
trying to SetValue after the field has been updated. So to put it simply as
just an example, I want to make it so that afterupdate Field1 will be changed
to 1, then using the same macro I want to have afterupdate Field2 value
changed to 1. So that I don’t have to keep reworking the same macro for
different fields (not that I am accutally trying to set the value of the
field to 1).
Thank-you for your time.
Steve Schapel - 01 Jun 2005 18:14 GMT
Menscandidus,
Try using...
[Screen].[ActiveControl]

Signature
Steve Schapel, Microsoft Access MVP
> I am trying to create a macro or VB code which refers to the current field
> which is selected. Because I am trying to create a macro which will be able
[quoted text clipped - 6 lines]
> field to 1).
> Thank-you for your time.
menscandidus - 01 Jun 2005 19:01 GMT
Thank-you for your help
> Menscandidus,
>
[quoted text clipped - 11 lines]
> > field to 1).
> > Thank-you for your time.