I came across this code for clearing a text box.
Is there a method to clear all controls without using a tag or control button when exiting a form?Code:Sub ClearFormText(frm As Form) Dim ctl As Control Dim txtBx As TextBox For Each ctl In frm.Controls If ctl.ControlType = acTextBox Then Set txtBx = ctl If txtBx.Tag = "YourFancyResetTextTag" Then txtBx.Value = Null End If End If Next ctl End Sub
I use a form to locate a record with a subform to display the record information.