validated data

S

Sam 44

I just star using Access 2003 and this may be a real easy questions but for
me its kind of hard.
I have a form whit several fields and want to validated the some of this
fields when I enter a new record, I will like to get a error mesage (because
this record allready exits) when I finish filling this field, at this moment
I get the mesage when I finish all the fields, wonder if I can have some data
validation and error mesage before I go to the next field.

I allready set up the no duplicated propery on the table.

Sorry for my english but I do have a better spanish.
 
V

Van T. Dinh

You can use the TextBox_BeforeUpdate Event of the TextBox Control to find
whether this value exists in the Table.

Check Access VB Help on the BeforeUpdate Event.
 
S

Sam 44

Thanks for your help. it works

Van T. Dinh said:
You can use the TextBox_BeforeUpdate Event of the TextBox Control to find
whether this value exists in the Table.

Check Access VB Help on the BeforeUpdate Event.
Click to expand...
 
Top