B
Bob Mullen
In a form that uses comboboxes - say cboP1 I am using the AfterUpdate event
to add records to a table. I am presently using the form's current event to
collect the value of the combobox when the record is entered, and the form's
Update event to collect the value of the combobox when the record is updated.
If the before and after are not equal I am deleting the appropriate record
from the table (ie: the previous person was deleted or changed to another).
This works fine.
However, if the value of the combox is changed without moving to a new
record in between I wind up failing to get the deletion from the table.
What event would be the best candidate for checking before and after values
and from there calling the deletion routine? Dirty, Change?
Help!
to add records to a table. I am presently using the form's current event to
collect the value of the combobox when the record is entered, and the form's
Update event to collect the value of the combobox when the record is updated.
If the before and after are not equal I am deleting the appropriate record
from the table (ie: the previous person was deleted or changed to another).
This works fine.
However, if the value of the combox is changed without moving to a new
record in between I wind up failing to get the deletion from the table.
What event would be the best candidate for checking before and after values
and from there calling the deletion routine? Dirty, Change?
Help!