closing a form with cancel button 
Author Message
 closing a form with cancel button

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 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.

------------------------------------------------
~~ Message posted from http://www.*-*-*.com/
~~View and post usenet messages directly from http://www.*-*-*.com/



Wed, 28 Jun 2006 05:54:54 GMT  
 closing a form with cancel button
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


Quote:

> 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 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.

> ------------------------------------------------
> ~~ Message posted from http://www.ExcelTip.com/
> ~~View and post usenet messages directly from http://www.ExcelForum.com/



Wed, 28 Jun 2006 12:47:30 GMT  
 closing a form with cancel button

Thanks HTH

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

------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/



Wed, 28 Jun 2006 23:45:52 GMT  
 
 [ 3 post ] 

 Relevant Pages 

1. Cancel/close form command button causes app to close

2. Cancel/close form command button causes app to close

3. Disable Access Close Button not Form Close Button?

4. Cancel Close Button

5. Canceling a lost focus event on a close button

6. Cancel record changes when Close button is clicked

7. Closing a query on cancel button click

8. User Form close buttons and timer close

9. Close command button allows form to be closed when required fields are left blank

10. Problem with Controlled Closing of a Form when exiting throught the Window-Close-Button


 
Powered by phpBB® Forum Software © phpBB Group