From: Risse on

"PeterM" <PeterM(a)discussions.microsoft.com> kirjoitti
viestiss�:FC5ECC25-0E73-42F1-8687-4CA6EFD643A4(a)microsoft.com...
>I have a listbox on a AC2003 form. I want to perform the following DLookup
> based on one of the columns/row in the single select listbox. I works
> great
> until the target table column contains a single quote. How do I resolve
> this
> situation?
>
> DLookup("Contents", "OutlookInbox", "Subject = '" & Me.List28.Column(2) &
> "'")
>
> Thanks for your help!