validated data

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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.
 
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...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Record Validation 3
Show a message if there are some duplicates 1
How to specify a validation rule with multiple criteria 3
Validation of a field 3
How to validate time format from a text field? 2
can't assign value to this object (update permisions problem?) 0
data validation 2
the value you entered isn't valid for this field 2

Back
Top