In Access 310 around the 8 minute mark you show how to put some VBA code that pops up a MsgBox and prevents users from changing the toggle button from an invoice to a quote if the order is paid. Then similar validation with the IsPaid check box if the order is a quote. In both cases the code seems to do its job but if I click on any other part of the form the MsgBox pops back up and does not let me out of the routine. If I try to close the form eventually I get a message that states “You can’t save this record at this time.” Although I compared my code against yours about 25 times I am sure I must have done something incorrect…
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Microsoft Access 310.