Multiple selection from SQL

[Clant1]

Im now trying to make my sql select two or more different values and display them with a report using access.

 strSQL = "SELECT * FROM tblcustomer where CustomerName = '" & Text1 & "'

What ive tried so far is using a Or but it didnt work at all.

[jamesd0142]

 strSQL = "SELECT * FROM tblcustomer where CustomerName = " & "'" & Text1.text & "'"

Try this

[Clant1]

 strSQL = "SELECT * FROM tblcustomer where CustomerName = " & "'" & Text1.text & "'"

Try this

Cheers got that working now but for some reason it tries to print the report that its looking at everytime now and theres not command telling it to print anywhere in my code

[jamesd0142]

Cheers got that working now but for some reason it tries to print the report that its looking at everytime now and theres not command telling it to print anywhere in my code

Im lost now :), Post your code and i'm sure some1 can point you in the rightdirection.

James

[Clant1]

ok.
The problem is in the second if statement for some reason when it looks at the report it wants to print it off. i think its something to do with teh strSQL2 value becuase it was when i added that it started breaking. The report asked for a parameter value when it loads as well which it shouldnt do becuase the SQL tells it not to but when it opens it also tries to print it as well. The report is a bad one which runs fine on its own and doesnt try to print anything else off.
[code=vb]
Private Sub Command15_Click ()

Dim rstCustomer As ADODB.Recordset
Dim conDatabase As ADODB.Connectio n
Dim strSQL As String
Dim strConditions As String
Dim strSQL2 As String

Set conDatabase = CurrentProject. Connection

If Check10.Value = True Then
strSQL = "SELECT * FROM tblcustomer where CustomerName = '" & Text1 & "'"

MsgBox (strSQL)
DoCmd.OpenForm "tblcustome r", , strSQL

'strSQL = strSQL & " OR '" & variable & "'" sql template


End If


If Check12.Value = True Then
strSQL2 = "SELECT * FROM tblorders where orderID = '" & Text3 & "'"
MsgBox strSQL2
DoCmd.OpenRepor t "tblorder", , strSQL2


End If

End Sub
[/code]

[QVeen72]

Hi,

I guess your Order Report is Based on a Query Object, which in turn needs a Parameter. Just check it, and Remove if any Parameters are there in the Query Object....

Regards
Veena

[Killer42]

The view property of the OpenReport method is your problem.

View Optional AcView. The view to apply to the specified report.

AcView can be one of these AcView constants.
acViewDesign
acViewNormal default Prints the report immediately.
acViewPivotChar t Not supported.
acViewPivotTabl e Not supported.
acViewPreview

[Clant1]

set it to preview fiddled alot with this guy from irc as well and got it working thanks alot again guys

[Killer42]

Glad we could help. :)