I am trying to use the following to check each Textbox in a user formPrivate Sub CheckForm()
Dim ctlText As Control
Application.ScreenUpdating = False
btnAmend.Enabled = False
For Each ctlText In frmAmend.Controls
If TypeName(ctlText) = "TextBox" Then
If ctlText <> "" Then...