closing a form with cancel button

  • Thread starter Thread starter bretheren
  • Start date Start date
B

bretheren

hi peers,

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.

how do i move the 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 "11". 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 "11" 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.
 
Press the Esc key to undo the entry in the current field. You can then click
on the Cancel button.

When you try to click the Cancel button, Access processes the events for the
current control it allows focus to move to the button. Undoing the control
(with Esc) returns it to the same state as if nothing had been entered
there.
 
Back
Top