Dear Community,

I step between my Controls and if it is a Checkbox I manipulate the name to the Name of the textbox and I try to use it with the Me. Command to reference to the Textbox in the Form for Searching in a Table. The problem is, that the Me. Command was interpreted as a String and not as a Reference on a Textbox in the Form. Is there a way to use the Me. Command with a string to get the value of the textbox in the form?

Dim ctl As Control
Dim sArray() As String
Dim sCheckboxname, sTextboxname, sTemp, stest As String


For Each ctl In Me.Controls
If (ctl.ControlType = acCheckBox) Then
sCheckboxname = ctl.Name
sArray = Split(sCheckboxname, "_")
sTextboxname = "txt_" & sArray(1)
sTemp = "Me." & sTextboxname


stest = "([" & sTextboxname & "] = ' """
stest = stest & " & " & sTemp & " & """
stest = stest & " ')"
sResult = "Select * from " & Me.Form.RecordSource & " where (" & stest & ")"

sCheckboxname = sTextboxname

End If

Set ctl = Nothing
Next ctl

With kind regards

Sönke