Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
clearing the fields of a record
- Thread starter skierm
- Start date
From code in one of my dbs...
'Reset all fields to Null
Dim frm As Form
Dim ctl As Control
Set frm = Screen.ActiveForm
For Each ctl In frm.Controls
Select Case ctl.ControlType
Case acTextBox, acComboBox, acListBox
ctl = Null
End Select
Next ctl
"I know what you're t'inkin', ma petite. Dat Gambit... still de suave one, no?"
'Reset all fields to Null
Dim frm As Form
Dim ctl As Control
Set frm = Screen.ActiveForm
For Each ctl In frm.Controls
Select Case ctl.ControlType
Case acTextBox, acComboBox, acListBox
ctl = Null
End Select
Next ctl
"I know what you're t'inkin', ma petite. Dat Gambit... still de suave one, no?"
- Status
Similar threads
- Locked
- Question
