Hi all,
I currently have a procedure that goes something like:
The only problem is that I know this is inefficient as I don't want to loop through ALL controls - only text or combo boxes. Is there any way I can define controls with those control types as the collection to loop through?
Thanks
I currently have a procedure that goes something like:
Code:
NullString = ""
For Each ctl In Me.Detail.Controls
If ctl.ControlType = acTextBox Or ctl.ControlType = acComboBox Then
If ctl.Tag Like "*" And IsNull(ctl.Value) Then
NullString = NullString & ctl.ControlSource & ", "
End If
End If
Next ctl
The only problem is that I know this is inefficient as I don't want to loop through ALL controls - only text or combo boxes. Is there any way I can define controls with those control types as the collection to loop through?
Thanks
