using multi column listboxes on access form - only shows one row?

A

Angus Comber

Hello

My rowsource in my 5 column listbox is:

SELECT StartDate,Companyname, PolicyName, SellingAgent, ClientComments FROM
Policy WHERE ClientID = lblClientID.caption

It works - but only shows 1 column. Even though have two rows in table with
this ClientID.

What am I doing wrong?

Angus
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Please help 31
Excel 2013: New row added automatically but first 2 columns Drop down lists not available... 0
Adding Items To a Multi-Column Listbox 2
"MSysCompactError", "System resource exceeded" & "You do not have the necessary permissions to use the...." 0
Transfer items from one listbox to another 4
Listbox query 3
populate listbox form database table 0
keep getting strange issue where cannot select a row in multicolumn listbox on Access Form 6

Top