closing a form with cancel button

[bretheren]

hi peers,

i have a data entry form (bound to a table) with CANCEL and SAV
buttons. some of the fields i have on this form are required and other
are optional. my problem is to do with the required fields.

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 an
further...but if you'd like to know what exactly i'm talking about the
please keep reading.

/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*
let's say user is doing some basic data entry and types the wrong dat
in one of the required fields. for instance DATE is a required fiel
and user types in "11". while doing that, he changes his mind an
clicks on CANCEL to get out of the form. as soon as he click on CANCE
button (or any other field for that matter) he gets the standard acces
error message complaining about invalid data. he DELETES "11" from th
field and clicks CANCEL but this time he gets an error messag
complaining about the null value.
/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*

so after all that explaining (and i hope it was understandable) wha
i'd like to do is be able to press the CANCEL button and get out of th
form.

any help will be appreciated

 

[TC]

Because of the specific problem you describe, it is >not possible< to have a
fully functional Cancel button on a bound form - end of story!

HTH,
TC

 

[bretheren]

Thanks HTH

Next time i'll remember to use a UNBOUND form.