Combo box keeps giving me "Enter Parameter Value"

[SeadnaS]

This is annoying as hell. Keep getting enter parameter value message. Don't understand why!

U have this in the after update event of typecombo:
Me!sizecombo.RowSource = "SELECT TP,Size_Type FROM " & Me!classcombo & " WHERE TP =" & Me!typecombo

When i open sizecombo it asks me to enter parameter value. What could be wrong. Everything looks fine to me.

 

[SeadnaS]

I mean I have this...

 

[dhookom]

Please provide more information...

Assuming ClassCombo is the name of a table or query, does it have any spaces in its name?

Is TP a text or numeric field?

Duane
Hook'D on Access
MS Access MVP

 

[SeadnaS]

classcombo is a combobox that lists tables. The tables are called LAC, LAH, DFX, VIV, LAO and LAX

TP is a text field that is in each table and so is Size_Type.

Hope you can help this is driving me nuts.

 

[SeadnaS]

Me!sizecombo.RowSource = "SELECT TP FROM " & Me.RecordSource & " WHERE TP = " & typecombo

This is what i'm trying now but i'm getting the same error.

 

[SeadnaS]

I got it to work!

Dim strSQL As String
strSQL = "SELECT DISTINCT Size_Type,TP FROM " & Me!classcombo & " WHERE TP = '" & Me!typecombo & "'"
Debug.Print strSQL
Me![sizecombo].RowSource = strSQL

Thats what i used, thanks!