Can't get distince values to show in Combo Box (1 Viewer)

CJ_London

Super Moderator
Staff member
Local time
Today, 10:10
Joined
Feb 19, 2013
Messages
16,553
Sounds like you have perhaps set the number of columns to 2, set the first columnwidth to 0 and have a rowsource only bringing through one column - per the example
 

jimtimber

Registered User.
Local time
Today, 10:10
Joined
Apr 25, 2014
Messages
118
I'm not sure how I change that?

All I did to set up a combo box was click on new report, select the table/field I want the combo box to show and followed the above link to get distinct records only.

How would I fix the column issue you mentioned please?
 

JHB

Have been here a while
Local time
Today, 11:10
Joined
Jun 17, 2012
Messages
7,732
If you can't get it post your database with some sample data + info where you've the problem.
 

jimtimber

Registered User.
Local time
Today, 10:10
Joined
Apr 25, 2014
Messages
118
Hi JHB, the database is massive and I couldn't upload. I could put the SQL for the query and some of the sample data from the combobox I'm trying to create, if that'd help at all?

Cheers,

J
 
Last edited:

vbaInet

AWF VIP
Local time
Today, 10:10
Joined
Jan 22, 2010
Messages
26,374
Let's see the SQL of the combo box's Row Source.
 

jimtimber

Registered User.
Local time
Today, 10:10
Joined
Apr 25, 2014
Messages
118
Let's see the SQL of the combo box's Row Source.


Hi VbaInet,

There's not much, its just

SELECT DISTINCT Tbl_FamilyRegularPayments.PaymentRun
FROM Tbl_FamilyRegularPayments;


Thanks,

J
 

vbaInet

AWF VIP
Local time
Today, 10:10
Joined
Jan 22, 2010
Messages
26,374
You're only returning one field. What is the Control Source of the Combo Box?
 

jimtimber

Registered User.
Local time
Today, 10:10
Joined
Apr 25, 2014
Messages
118
Hi, there isn't a control source? Please see the attached.

I looked at some of the other combo boxes we use as report filters and they don't have anything in the control source either.

J
 

Attachments

  • combo control.png
    combo control.png
    69.6 KB · Views: 75

vbaInet

AWF VIP
Local time
Today, 10:10
Joined
Jan 22, 2010
Messages
26,374
Column Count: 1
Column Widths: 2.54cm
Bound Column: 0
 

jimtimber

Registered User.
Local time
Today, 10:10
Joined
Apr 25, 2014
Messages
118
Woohoo, that works :) Thank you for your help :) I've got about 6 different combos to make so this will help as a guide.

Is there a way to sort the combo list alphabetically easily or would I need to set up a separate numeric column to sort them by?

Thanks, this has been driving me nuts :)
 

Users who are viewing this thread

Top Bottom