BeforeUpdate

  • Thread starter Thread starter shampoo
  • Start date Start date
S

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
 
shampoo said:
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.
Click to expand...

If Not IsNull(Me!IntField.OldValue) Then ...
 
Thanx but now prompts error Access cant find the filed "IntField" i want
that applied on my text and combo fields on form!
 
shampoo said:
Thanx but now prompts error Access cant find the filed "IntField" i
want that applied on my text and combo fields on form!
Click to expand...

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.
 
Back
Top