Access 2003 DE routine problem

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

Guest

I have an app where users are supposed to enter Items and their values. Only
two fields on the de screen - items and values - and the values are supposed
to be unique.
Item table structure:
ID - Autonumber
Item - description text
Value - number indexed no duplicates
I need a de routine where if they type in a value that's already there -
they get a message that their supposed to enter a slightly different value.
I have in the validation text in the table definition:
Please change the value slightly !
But it doesn't show up when they enter a duplicate value - nothing shows up
and they can't go any further or save the record.
This is a menu driven app which just opens the de screen for this routine.
All replies appreciated.
Frank in Spokane after Bloomsday
 
Hi,
you can add a unique index on Item to your table, then in form error event
catch for duplicate index error and then show a message box with
explanations
 
Back
Top