Stevehewitt
IS-IT--Management
Hey,
I have looked this up on Google Groups as well as the Advanced Search tool on TT but nothing that seems to work.
Basically I need to find a line of code that ensures that the data entered into the form is not saved.
I have a form and subform joined using a order number. At the moment if the payment terms or gross profit percent are below a specificed amount then a supervisor password is required. The password is asked for at the 'save' button. If the data is OK (Terms are 30 days or under and the GP% is above the set level) then the record is saved with a popup. If the data has not met the criteria then a input box requests a password. If incorrect then the data is still not saved. If its correct then its saved with a message box.
I also have a close buttton where if the record has not been saved then its not recorded. (So either it must meet the sales criteria or have a password).
Sorry for the lengthy post! Can anyone help?
Cheers,
Steve.
I have looked this up on Google Groups as well as the Advanced Search tool on TT but nothing that seems to work.
Basically I need to find a line of code that ensures that the data entered into the form is not saved.
I have a form and subform joined using a order number. At the moment if the payment terms or gross profit percent are below a specificed amount then a supervisor password is required. The password is asked for at the 'save' button. If the data is OK (Terms are 30 days or under and the GP% is above the set level) then the record is saved with a popup. If the data has not met the criteria then a input box requests a password. If incorrect then the data is still not saved. If its correct then its saved with a message box.
I also have a close buttton where if the record has not been saved then its not recorded. (So either it must meet the sales criteria or have a password).
Sorry for the lengthy post! Can anyone help?
Cheers,
Steve.