Listbox Rowsource

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Shannon - 29 May 2008 01:56 GMT

Hi All,

I have the following line of code that will not work and I can't for the
life of me work out why.

Forms!searchform!List12.RowSource = "SELECT MemberData.Surname,
MemberData.FirstName, MemberData.Code FROM MemberData WHERE
(((MemberData.Surname) Like " & Forms.searchform.Surname & " * ));"

I'm sure it is staring me in the face but he brain isn't working today.

Any assistance would be greatly apprciated.

Reply to this Message

ruralguy - 29 May 2008 02:37 GMT

Strings need to be enclosed within quotes.

WHERE MemberData.Surname Like '" & Forms.searchform.Surname & "'* ;"

>Hi All,
>
[quoted text clipped - 8 lines]
>
>Any assistance would be greatly apprciated.

Signature

RuralGuy (RG for short) aka Allan Bunch MS Access MVP - acXP WinXP Pro
Please post back to this forum so all may benefit.

Reply to this Message

Shannon - 29 May 2008 02:53 GMT

Thanks.

> Strings need to be enclosed within quotes.
>
[quoted text clipped - 12 lines]
> >
> >Any assistance would be greatly apprciated.

Reply to this Message

ruralguy - 29 May 2008 14:39 GMT

You're welcome.

>Thanks.
>
[quoted text clipped - 3 lines]
>> >
>> >Any assistance would be greatly apprciated.

Signature

RuralGuy (RG for short) aka Allan Bunch MS Access MVP - acXP WinXP Pro
Please post back to this forum so all may benefit.

Reply to this Message