Hello
try this code
![]()
Private Sub Clearfrm_Click() Dim ctl As Control For Each ctl In Me.Controls If TypeName(ctl) = "TextBox" Or TypeName(ctl) = "ComboBox" Then If ctl.Name <> "box5" Then ctl.Value = "" End If End If Next ctl End Sub
Hello
try this code
![]()
Private Sub Clearfrm_Click() Dim ctl As Control For Each ctl In Me.Controls If TypeName(ctl) = "TextBox" Or TypeName(ctl) = "ComboBox" Then If ctl.Name <> "box5" Then ctl.Value = "" End If End If Next ctl End Sub
< ----- Please click the little star * next to add reputation if my post helps you
Visit Forum : From Here
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks