Hey guys, take your time with this - i'm not in a hurry, it's just slipped my mind.
I'm reseting the form controls back to their default value. My code is as follows.
The problem is the default value returns the literal string instead of the applied value. For instance if the default value was '=Null' then '=Null' is what you would actually see. I've tried ctl.requery but this does not work either.
Any suggestions?
I'm reseting the form controls back to their default value. My code is as follows.
Code:
For Each ctl In Me.Controls
If ctl.Name Like "cbo*" Or ctl.Name Like "txt*" Then
ctl.Value = ctl.DefaultValue
End If
Next ctl
The problem is the default value returns the literal string instead of the applied value. For instance if the default value was '=Null' then '=Null' is what you would actually see. I've tried ctl.requery but this does not work either.
Any suggestions?