THANKS MACCA,

Its now working ok.



"folbabe" <folbabe@hotmail.com> wrote:
>
>Hi Macca
>
>I tried but it gives me a syntax error in the line below
>
>Rs!Field1 & vbtab & Rs!Field2
>
>Hope to read from you soon
>
>
>"macca" <tim@agcl.net> wrote:
>>
>>"folbabe" <folbabe@hotmail.com> wrote:
>>>
>>>Hi Folks,
>>>
>>>Can anybody show me how to display two fields in my database table as

two
>>>columns in my listbox
>>>
>>>Thanks in advance.
>>>
>>>
>>>Regards

>>
>>Open a recordset with the two fields in it and then to the following:
>>
>>Do Until Rs.EOF
>> Listbox1.AddNew
>> Rs!Field1 & vbtab & Rs!Field2
>>Loop
>>
>>
>>

>