B
bretheren
hi peers,
okay this is a bit of a tricky situation to explain but i'll try to be
as simple as possible.
i have a data entry form (bound to a table) with CANCEL and SAVE
buttons. some of the fields i have on this form are required and others
are optional. my problem is to do with the required fields.
although the scenario is somewhat unlikely but i want to be able to
handle it through code. so here it is:
how do i move cursor from a required field AFTER it has been changed.
if the above line makes sense to you, then you don't need to read any
further...but if you'd like to know what exactly i'm talking about then
please keep reading.
/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*
let's say user is doing some basic data entry and types the wrong data
in one of the required fields. for instance DATE is a required field
and user types in "Car". while doing that, he changes his mind and
clicks on CANCEL to get out of the form. as soon as he click on CANCEL
button (or any other field for that matter) he gets the standard access
error message complaining about invalid data. he deletes "Car" from the
field and clicks CANCEL but this time he gets an error message
complaining about the null value.
/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*
so after all that explaining (and i hope it was understandable) what
i'd like to do is be able to press the CANCEL button and get out of the
form.
any help will be appreciated.
okay this is a bit of a tricky situation to explain but i'll try to be
as simple as possible.
i have a data entry form (bound to a table) with CANCEL and SAVE
buttons. some of the fields i have on this form are required and others
are optional. my problem is to do with the required fields.
although the scenario is somewhat unlikely but i want to be able to
handle it through code. so here it is:
how do i move cursor from a required field AFTER it has been changed.
if the above line makes sense to you, then you don't need to read any
further...but if you'd like to know what exactly i'm talking about then
please keep reading.
/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*
let's say user is doing some basic data entry and types the wrong data
in one of the required fields. for instance DATE is a required field
and user types in "Car". while doing that, he changes his mind and
clicks on CANCEL to get out of the form. as soon as he click on CANCEL
button (or any other field for that matter) he gets the standard access
error message complaining about invalid data. he deletes "Car" from the
field and clicks CANCEL but this time he gets an error message
complaining about the null value.
/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*
so after all that explaining (and i hope it was understandable) what
i'd like to do is be able to press the CANCEL button and get out of the
form.
any help will be appreciated.