2 column list box row source

  • Thread starter Thread starter NHMM
  • Start date Start date
N

NHMM

I am trying to populate a 2-column list box using distict values from a
query. I can get it to work with 1 column but not two. I keep getting a
missing operator error on the second column.

My row source currently looks like:
SELECT DISTINCT qry_quote.tag, qry_quote.tag description FROM qry_quote

The two columns are directly related, for example:
TAG TAG DESCRIPTION
C Compressor
F Filter
V Valve
etc, each tag has a unique description

What am I missing?
Thanks,
NHMM
 
The problem is the space in the field name.

Most of us advise not to include spaces. If you do, you must enclose the
name in square brackets:

SELECT DISTINCT qry_quote.tag, qry_quote.[tag description] FROM qry_quote
 

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

One column of a list box does not display for all users. 6
2nd list box not writing to text box 1
Search Unbound Column in List Box 5
Option Group ListBox Row Source "Expected end of statement" 0
List box selection into combo box 2
Find cell entry contained anywhere within a text string 2
Access MS access forms list box problems 1
auto populate text box based on combo box value 1

Back
Top