How to check check which control is active

[Adrian]

Access 2000

I want to run some code on the Form_BeforeInsert event. But if the user is
entering data into one particular text box I do not want the code to run.
Something like...

If user not in control 'txtDate' then
run some code here
end if

How can I check which control the user is entering data before running the
code?

Thanks for any help.

Adrian

[Salad]

Adrian wrote:

Access 2000

I want to run some code on the Form_BeforeInsert event. But if the user is
entering data into one particular text box I do not want the code to run.
Something like...

If user not in control 'txtDate' then
run some code here
end if

How can I check which control the user is entering data before running the
code?

Thanks for any help.

Adrian

See if ActiveControl will help.

[Adrian]

Salad,

Thanks very much

Adrian

"Salad" <oi*@vinegar.com> wrote in message
news:0H*****************@newsread3.news.pas.earthl ink.net...

Adrian wrote:

Access 2000

I want to run some code on the Form_BeforeInsert event. But if the user is entering data into one particular text box I do not want the code to run. Something like...

If user not in control 'txtDate' then
run some code here
end if

How can I check which control the user is entering data before running the code?

Thanks for any help.

Adrian

See if ActiveControl will help.