Change Variable form recordsource 1

[hartwell]

Hi Guy's

Trying to change a variable form's record source

here is what i have (ive only included what is needed)

Dim strSubFormName As String

strSubFormName = Forms![frmIndex].txtSearch.Tag

rs = "(SELECT * FROM tblMatrixCoreData WHERE tblMatrixCoreData.Accountno = " & strSearchValue & ")"

Forms![frmIndex]![strSubFormName].RecordSource = rs

i just get field strsubformname not found

 

[PHV]

Perhaps something like this ?
rs = "SELECT * FROM tblMatrixCoreData WHERE Accountno=" & strSearchValue
Forms![frmIndex].Controls(strSubFormName).Form.RecordSource = rs

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886