Two Formulas Inside One IF Function

[Eranka]

HI

If Frame3 = 1 Then
strRowsource = "SELECT [Titile],[Surname],[Given_Names] AS [Given Names],[Marital_Status] AS [Marital Status],[Country_Of_Residence] AS [Country of Residence],[Email],[Mobile_Number] AS [Mobile Number],[Home_Phone_Number] AS [Home Phone Number],[Address] " _               
                & "FROM Alumni_List " _
                & "WHERE [Mobile_Number] Like '*" & Me.txtSearch.Text & "*'"


strRowsource2 = "SELECT SELECT [Course_Completed] AS [Course Completed],[Other_Courses_Followed] AS [Other Courses Followed],[Student_ID] AS [Student ID],[Year_Of_Completion] AS [Year Of Completion],[Completed_Semester] AS [Completed Semester] " _
                & "FROM Alumni_List " _
                & "WHERE [Mobile_Number] Like '*" & Me.txtSearch.Text & "*'"

Please see above, is this the correct way to use two functions inside one IF loop.

[June7]

All you are doing is populating 2 variables which is not a problem. What are you really trying to accomplish?

[Eranka]

Hey

creating a search form, but above code doesn't working and no error messages as well.

[June7]

Code shown is not a complete procedure. Just setting a variable doesn't do anything.

Review http://allenbrowne.com/ser-62.html

[GinaWhipp]

Hmm, where's the rest of the code? What are they feeding a Combo Box, List Box? Do you requery the controls after altering the row source?