[RESOLVED] Control.TypeOf Question

[Tech99]

Thanks Bonnie, that is nice solution and more useable when there are several user controls in form.

Other solution is to directly point with control name like;

If TypeOf C Is TextBox Or TypeOf C Is ComboBox Or UCase(C.Name) = "GRDORDERROWS" Then...

Another question. I am doing dynamic sql clause by code, control name and it's data is dealt with part of the sql queries where clause. Control name is same as db field name and data is search key. Controls - ownerdrawn and/or created dynamically by controls.add method fex. UserControl.Controls.Add("VB.TextBox", "tbEdit")) in usercontrol, are not detected either with frm.Controls.

So.. Opinions what is the elegant way to get the control name inside usercontrol?

Controls are named after db fieldnames. I am thinking on putting field names to array, but if names could be read by code (public method inside usercontrol), then that is obviously unneccessary?

Public Property Get ucControl() As Object
    Set ucControl = UserControl.Controls
End Property

but calling it's data by
grdOrderRows.ucControl.Text

Generates 438 object does not support this method - error.
So how to correct that? Tried with Set ucControl = UserControl.Controls.tbEdit, UserControl.Controls.TbEdit.Text and UserControl.Controls.TextBox.TbEdit.Text as per above example - no worky. Idea is to get the control name and it's data as per above.