Keith, the simplest approach would be to just refer to the OldValue
property, and use error-handling to recover if the property doesn't apply.
There are too other factors to consider, such as whether the check box is
part of an option group (examine its Parent property), or bound to a
non-updatable field, or whether the check box is unbound (in which case the
OldValue does not generate an error, but is not useful), and so on.
--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"Keith Wilby" <here@there.com wrote in message
news:452d0c69_1 @glkas0286.gree nlnk.net...
In A2k3 is it possible to determine if the OldValue property for a check
box exists using code?
>
Thanks.
>
Keith.
"Allen Browne" <AllenBrowne@Se eSig.Invalidwro te in message
news:452d115c$0 $1442$5a62ac22@ per-qv1-newsreader-01.iinet.net.au ...
Keith, the simplest approach would be to just refer to the OldValue
property, and use error-handling to recover if the property doesn't apply.
Thanks Allen, I'll look into that.
>
There are too other factors to consider, such as whether the check box is
part of an option group (examine its Parent property), or bound to a
non-updatable field, or whether the check box is unbound (in which case
the OldValue does not generate an error, but is not useful), and so on.
>
Comment