Hi,
I’m trying to write some VBA code to assemble different SQL code according to user settings on an Access form. The code below is not the actual code but shows the problem I have been having very simply. Help on this would be much appreciated.
Dim SQLsearch1 As String
Dim SQLsearch2 As String
Dim A As Integer
SQLsearch1 = "Please Help"
SQLsearch2 = "I would appreciate it"
For A = 1 To 2
MsgBox ("SQLsearch" & A)
Next A
This displays “SQLsearch1” and “SQLsearch2” in the message box. How can I get it to display “Please Help” and “I would appreciate it”?