Combo Box Difficulty

[stampr18]

I used this same code in another form, but it wont' work on this form. Can you see something that I am missing?

SELECT DISTINCT [TBLProduct].[Product] FROM TBLProduct WHERE ((([TBLProduct].[Manufacturer])=[FORMS]![FRMRECEIPT].[FRMRECEIPTSUBFORM]!Manufacturer)) ORDER BY [TBLProduct].[Product];

 

[boblarson]

If Manufacturer is text:

"SELECT DISTINCT [TBLProduct].[Product] FROM TBLProduct WHERE ((([TBLProduct].[Manufacturer])='" & [FORMS]![FRMRECEIPT].[FRMRECEIPTSUBFORM]!Manufacturer & "')) ORDER BY [TBLProduct].[Product];"

If Manufacturer is a number and not text, then :

"SELECT DISTINCT [TBLProduct].[Product] FROM TBLProduct WHERE ((([TBLProduct].[Manufacturer])=" & [FORMS]![FRMRECEIPT].[FRMRECEIPTSUBFORM]!Manufacturer & ")) ORDER BY [TBLProduct].[Product];"