After Update Code

[JK]

I have a form to enter in new projects. Currently when someone enters in a
new project they must fill in all the required information in order to save
the record and then at that point the system will tell them if that project
is already entered or not. Is there some code that I can put in the
afterupdate field that will check for this once the person attempts to move
into the next box?

 

[Chegu Tom]

It is probably better in the before update event. That way you can cancel
the update if


if dcount( the paramenters to count the number of records with that key
field)>0 then
msgbox "You already have that project number"
cancel=true
endif

 

[JK]

I actually have such a combo box but the users don't always use it. They
prefer to just enter things in new