Row Source in Combo Box Question

[d9pierce1]

Hi all,
One more thing i am having issues with.
I have a tblReference that has ReferenceID (AutoNum), BusinessID(Num), ReferenceName(txt)

What I am seeking to do in my combo is select only the Reference Names that are associated to BusinessID's

I have used both the followings rowsource's and neither one works.

SELECT [tblReference].[ReferenceID], [tblReference].[BusinessID], [tblReference].[ReferenceName] FROM tblReference "WHERE BusinessID = '" & Me.BusinessID & "'" ORDER BY [ReferenceName]; 

SELECT [tblReference].[ReferenceID], [tblReference].[BusinessID], [tblReference].[ReferenceName] FROM tblReference "WHERE BusinessID = " & Me.BusinessID & "" ORDER BY [ReferenceName];

Any help would be wonderful.... I beleive the where statement is the problem but cant figure out what i am doing wrong with it?
Thanks


Dave

[Minty]

If this is in the underlying query then you need to use the form references.

SELECT [tblReference].[ReferenceID], [tblReference].[BusinessID], [tblReference].[ReferenceName] 
FROM tblReference 
WHERE BusinessID = Forms!YourFormName!TxtBoxControlBusinessID ORDER BY [ReferenceName];

If you are building it VBA then your concatenation is all out of kilter ;

SELECT [tblReference].[ReferenceID], [tblReference].[BusinessID], [tblReference].[ReferenceName] 
FROM tblReference WHERE BusinessID = " & Me.BusinessID & " ORDER BY [ReferenceName]"

[d9pierce1]

Worked like a charm
Thank you very much!
Dave

[Welshgasman]

If you put all that into a string variable, then you can Debug.Print that variable.?
That then normally shows you, where you have gone wrong.