BeforeUpdate

[shampoo]

Hi all,

i have problem with BeforeUpdate event on my text and combo boxes'.
I used exactly same code from this article
http://support.microsoft.com/?kbid=197103
But i only want that this event prompts only when existing data has been
changed not for entering new data.

I guess some code must me added to check if field is empty, if it is dont
prompt that if it aint prompt, but i am newbie with VB.

Thanx

 

[Rick Brandt]

i have problem with BeforeUpdate event on my text and combo boxes'.
I used exactly same code from this article
http://support.microsoft.com/?kbid=197103
But i only want that this event prompts only when existing data has
been changed not for entering new data.

I guess some code must me added to check if field is empty, if it is
dont prompt that if it aint prompt, but i am newbie with VB.

If Not IsNull(Me!IntField.OldValue) Then ...

 

[shampoo]

Thanx but now prompts error Access cant find the filed "IntField" i want
that applied on my text and combo fields on form!

 

[Rick Brandt]

Thanx but now prompts error Access cant find the filed "IntField" i
want that applied on my text and combo fields on form!

Sorry, I neglected to remove the sample field name that I used for testing. You
need to replace "IntField" with the name of the control on your form.