How, after I submit a record from a subfrom, do I refresh the form to have its original defualt values.
I wrote
For Each ctl In Me.Controls
If ctl.ControlType = acTextBox Then
ctl.Value = ctl.DefaultValue
End If
Next ctl
But this puts quotes in the field with defualt value. How do I get rid of the quotes?
SLC: Greatest snow on earth!!!
I wrote
For Each ctl In Me.Controls
If ctl.ControlType = acTextBox Then
ctl.Value = ctl.DefaultValue
End If
Next ctl
But this puts quotes in the field with defualt value. How do I get rid of the quotes?
SLC: Greatest snow on earth!!!