Run-time error '2465'

[whojstall11]

I have a code that giving me the run time error can anybody help

Private Sub Command7_Click()
Dim strFilter As Integer

strFilter = [PO Number] = [Forms]![PO Search Report]!PONumber
DoCmd.OpenReport "Purchase Order Report", acViewReport, , _
[PO Number] = Me!PONumber.Value

End Sub

I know it has something to do with the data type integer but I dont know how to fix it.

 

[pbaldy]

See the correct syntax here:

http://www.baldyweb.com/wherecondition.htm

 

[boblarson]

Private Sub Command7_Click() 
Dim strFilter As [B][COLOR=red]String[/COLOR][/B]
 
strFilter = [B][COLOR=red]"[/COLOR][/B][PO Number] =[B][COLOR=red]" &[/COLOR][/B] [Forms]![PO Search Report]!PONumber 
DoCmd.OpenReport "Purchase Order Report", acViewReport, , [B][COLOR=red]strFilter[/COLOR][/B]
 
End Sub

If the command button is on PO Search Report, then you just need:

Private Sub Command7_Click() 
Dim strFilter As [B][COLOR=red]String[/COLOR][/B]
 
strFilter = [B][COLOR=red]"[/COLOR][/B][PO Number] =[B][COLOR=red]" &[/COLOR][/B] [B][COLOR=blue][PONumber ][/COLOR][/B]
DoCmd.OpenReport "Purchase Order Report", acViewReport, , [B][COLOR=red]strFilter[/COLOR][/B]
 
End Sub

 

[whojstall11]

Ok i tried to combine both ways still no luck

strFilter = "[PO Number] =" & [Forms]![PO Search Report]!PONumber

DoCmd.OpenReport "Purchase Order Report", acViewReport, , _
"[PO Number] ='" & Me.PONumber & "'" & " or DateOrdered ='" & Me.DateOrdered & "'"

and it gives me an syntax error when I but in # for the dateordered

 

[boblarson]

Ok i tried to combine both ways still no luck

strFilter = "[PO Number] =" & [Forms]![PO Search Report]!PONumber
 
DoCmd.OpenReport "Purchase Order Report", acViewReport, , _
"[PO Number] ='" & Me.PONumber & "'" & " or DateOrdered ='" & Me.DateOrdered & "'"

What the heck? You didn't show DateOrdered in there at all before.

And why the hell are you creating the strFilter if you aren't going to use it?

And Dates don't get quotes surrounding them, they get octothorpes (#).

And you don't have the keyword AND in between the two:

strFilter = "[PO Number] =" & Me.PONumber & " AND [DateOrdered]=#" & Me.DateOrdered & "#"
 
DoCmd.OpenReport "Purchase Order Report", acViewReport, , strFilter

Also, why are you posting using the PHP tags instead of the CODE tags which is the one with the # on the button?

 

[whojstall11]

Yea make sense but it should be an "or" instead of an "and" i want people to be able to search by either. When i add an "or" i get runtime error 3075

 

[boblarson]

Is PO Number a number or is it text? If it is text then it needs quotes.

And how is the date stored? Are you using mm/dd/yyyy or dd/mm/yyyy?

 

[whojstall11]

Po is a number an date i use the date picker and its mm/dd/yyyy

 

[boblarson]

Po is a number an date i use the date picker and its mm/dd/yyyy

Okay, so post what you currently have (I assume you did some attempt at fixing it already based on what I posted previous).

 

[whojstall11]

I took out the strFilter too

Private Sub Command7_Click()
DoCmd.OpenReport "Purchase Order Report", acViewReport, , _
"PO Number =" & Me!PONumber.Value & " or [DateOrdered]=#" & DateOrdered.Value & "#"

End Sub

 

[boblarson]

Slight change:

Private Sub Command7_Click()
DoCmd.OpenReport "Purchase Order Report", acViewReport, , _
"PO Number =" & Me!PONumber & " or [DateOrdered]=#" & [B][COLOR=red]Me![/COLOR][/B]DateOrdered & "#"

End Sub

You don't need the .Value part either as that is the default.

But another question came up - is the PONumber field and the DateOrdered field on the same form as the command button? Or is it in a subform?

 

[pbaldy]

You have to bracket the field name due to the inadvisable space:

[PO Number]

 

[boblarson]

You have to bracket the field name due to the inadvisable space:

[PO Number]

I'm on it today (NOT!!!)

 

[pbaldy]

Earlier versions had the brackets, but apparently they got dropped along the way.

 

[whojstall11]

Yea they are both on the same from as the button. Im getting an "Syntax error (missing operator in query expression 'PO Number = 3011 or [DateOrdered]=##)' "

 

[boblarson]

Yea they are both on the same from as the button. Im getting an "Syntax error (missing operator in query expression 'PO Number = 3011 or [DateOrdered]=##)' "

Okay, that shows two problems.

1. Which Paul pointed out, you need brackets around the PO Number part of the code. [PO Number]=

2. And your form has no date selected. It is showing the # from both sides but there is no date. Select a date on your form and move to another control from that control.

 

[whojstall11]

Yea doesnt work either

Private Sub Command7_Click()
DoCmd.OpenReport "Purchase Order Report", acViewReport, , _
"[PO Number]=" & Me!PONumber & " or [DateOrdered]=#" & Me!DateOrdered & "#"

End Sub

 

[whojstall11]

Ok that seem to work thank you

 

[boblarson]

Yea doesnt work either

Private Sub Command7_Click()
DoCmd.OpenReport "Purchase Order Report", acViewReport, , _
"[PO Number]=" & Me!PONumber & " or [DateOrdered]=#" & Me!DateOrdered & "#"
 
End Sub

So you have actually selected a date in the control which is named DateOrdered? If that is not the name of the control which you are using to select the date, then replace it with the actual name of the control you are using.

If you are getting the error about syntax which shows this:

or [DateOrdered]=##)' "

then it means that there is no value in the control which you are using for your date selection. You need to look into why that is the case.