Display 2 fields in my a database table in a list box

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

"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

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
>
>
>