C
Chris Strug
Hi,
First of all, my apologies for crossposting, I'm not sure which group this
is best suited to. Please only respond to a single group.
A behaviour in Access is puzzling me.
I have two systems, one existing as a bog standard Access MBD and the other
as an Access ADP project linked an SQL 2000 Server.
I am trying to rewrite the MDB as the ADP and have hit a snag.
In my old form, the validation was carried out in the "BeforeUpdate" event
of the form. This worked quite well. Once the user had completed the data
and moved from the record, the BeforeUpdate Event ran, any errors were
trapped and it worked just fine.
However, in the ADP, the BeforeUpdate event runs as soon as the user enters
a value into the record - i.e. as soon as they enter a single character in
any field in the new record the event runs and the thing traps everything
because obviously the user hasn't had a chance to enter anything into the
record.
Is there a reason why the two events are different in MDB's and ADP's and is
there a way I can get the MDB functionality in the ADP project?
Many thanks
Chris Strug
First of all, my apologies for crossposting, I'm not sure which group this
is best suited to. Please only respond to a single group.
A behaviour in Access is puzzling me.
I have two systems, one existing as a bog standard Access MBD and the other
as an Access ADP project linked an SQL 2000 Server.
I am trying to rewrite the MDB as the ADP and have hit a snag.
In my old form, the validation was carried out in the "BeforeUpdate" event
of the form. This worked quite well. Once the user had completed the data
and moved from the record, the BeforeUpdate Event ran, any errors were
trapped and it worked just fine.
However, in the ADP, the BeforeUpdate event runs as soon as the user enters
a value into the record - i.e. as soon as they enter a single character in
any field in the new record the event runs and the thing traps everything
because obviously the user hasn't had a chance to enter anything into the
record.
Is there a reason why the two events are different in MDB's and ADP's and is
there a way I can get the MDB functionality in the ADP project?
Many thanks
Chris Strug
