Change Event

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

Guest

I have a bound control on a form that I am using the Change event to check
whether the value entered by the user is already in the table. This is all
working fine when the user edits one of the existing records.

When the user starts a new record, enters a value that already exists, but
clicks off the new record to an existing record(to stop adding the new
record), a blank record is added to the table.

Does anyone have any suggestions on how to prevent adding this blank record?

Thanks.
 
Along with that, remember that onchange is triggered with EVERY
keystrock, whereas the before update is only triggered, basically, when
the field loses focus
 
There is also a field beforeupdate event that I have used almost the
same as lose focus for tests that involve Only the one field.
However the form's beforeupdate would perhaps work better for multiple
field update logic.

As always seems to be the way in Access - There's more than one way to
do a lot of the activities.

Ron
 
Back
Top