HElp guys, i can't understand the error

Angeluz

Registered User.
Local time
Today, 00:15
Joined
Dec 28, 2006
Messages
10
Private Sub cmdSearch_Click()
Dim LSQL As String
Dim LSearchString As String

If Len(txtSearchString) = 0 Or IsNull(txtSearchString) = True Then
MsgBox "You must enter a search string."

Else

LSearchString = txtSearchString

'Filter results based on search string
LSQL = "select * from MCS_All_Services_v8"
LSQL = LSQL & " where Country LIKE '*" & LSearchString & "*'"

Form_MCS_All_Services_v8_subform.RecordSource = LSQL

lblTitle.Caption = "Customer Details: Filtered by '" & LSearchString & "'"

'Clear search string
txtSearchString = ""

MsgBox "Results have been filtered. All Company Names containing " & LSearchString & "."

End If




it kept mention that is Identifier Under Cursor Not Recognized? on the line "FORM_MCS_All_Services_v8_subform. RecordSource....

ideas people?
 
PHP:
Form_MCS_All_Services_v8_subform.RecordSource = LSQL

should be

PHP:
forms!MainFormName!subFormName.Recordsource=LSQL
 

Users who are viewing this thread

Back
Top Bottom