Hi Richard, I am working with the check register and want to make sure that the user cannot add a check if the action is a Credit, so I added the following code to the beginning of the double click event for ChkNum. If Credit <> 0 Then Me.ChkNum.Enabled = False Exit Sub End If You probably have a better way and I would hope you consider this for an update on Check Register. Thanks John Davy
Yeah, that would work. I would probably put the code in the BeforeUpdate field for the ChkNum field so you could issue a warning message and then cancel the event which wouldn't allow them to save a value. Right now you're only preventing the double-click auto-numbering. Also, in the AfterUpdate event for the Credit field, and in the OnCurrent event you would maybe want to hide the ChkNum field accordingly. Good idea for the next version.
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.
