A family of Microsoft relational database management systems designed for ease of use.
Thank you. That did the trick.
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Below is my on enter code for txt_GAID_Enter. When entering the textbox it tests for a couple of conditions and then closes the form. Well, that is the intent anyway. When it gets to the close form line it returns an error "This action can't be carried out while processing a form or report event.". Not sure what event it would be referring to.
Private Sub txt_GAID_Enter()
'On Error Resume Next
'By-Passes Per Capita check it Aerrie is from out of state
If txt\_PerCapita\_Status = "NA" Then
Exit Sub
End If
'Tests that Per Capita's have been paid
If txt\_PerCapita\_Status = "Not Paid" Then
MsgBox "This Aerie has not paid their Per Capita taxes and therefore cannot register Delegates for convention." & vbCrLf & vbCrLf & \_
"This form will now close."
End If
'Tests that Additional Allowed Delegates is greater than 0
If txt\_AdditionDelegates\_Allowed = 0 Then
MsgBox "This Aerie has already used their Allowed Delegates." & vbCrLf & vbCrLf & \_
"This form will now close."
End If
DoCmd.Close acForm, "frm\_Registration", acSaveNo
End Sub
A family of Microsoft relational database management systems designed for ease of use.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
Thank you. That did the trick.
The proper event for Validation code is the Before Update event. Depending on what you are validating that could be the control's BeforeUpdate or the form's BeforeUpdate.
We would need to see what other code procedures are in the module. Especially in the Open, Load and Current events.