Syntax missing operator 2

[SeadnaS]

Keep getting a Syntax Error missing operator message on the following code:

Size_Type = '13010' And WHERE TP = 'BP'

Don't know whats wrong with it.

Heres the full code from VBA:

Me!lotbox.RowSource = "SELECT LOT_NO FROM " & Me.RecordSource & " WHERE Size_Type = '" & Me.sizecombo & "' And WHERE TP ='" & Me!typecombo & "'

 

[BigRed1212]

I don't think you need the second WHERE.

I think:

Me!lotbox.RowSource = "SELECT LOT_NO FROM " & Me.RecordSource & " WHERE Size_Type = '" & Me.sizecombo & "' And TP ='" & Me!typecombo & "'"

would be sufficient.

 

[Andrzejek]

I think BigRed is into something, but I would also recomend something like this:
[tt]
Dim strSQL As String

strSQL = "SELECT LOT_NO FROM " & Me.RecordSource & " WHERE Size_Type = '" & Me.sizecombo & "' And TP ='" & Me!typecombo & "'"

Debug.Print strSQL

Me!lotbox.RowSource = strSQL[/tt]

This way it is easy to see what SQL you are trying to run.

Have fun.

---- Andy