Re: Need help with this code to set the List Row Source

On Jun 24, 5:46=A0am, "Douglas J. Steele"
<NOSPAM_djsteele@[EMAIL PROTECTED]
> wrote:
> Slight correction. If the second column of the combo box is going to
retur=
n
> the string
>
> Like 'T*'
>
> then the SQL should be
>
> =A0strSelected =3D "Select * from Products where productid " & _
> =A0 =A0 Me![Combo24].Column(1)
>
> (i.e.: you should NOT have an equal sign in there)
>
> --
> Doug Steele, Microsoft Access MVPhttp://I.Am/DougSteele
> (no e-mails, please!)

shouldn't it be...

strSelected =3D "Select * from Products where productid LIKE '" & _
>     Me![Combo24].Column(1) & "*'"