Combo Box Issues

[Guest]

I have a unlinked combo box which has a source file based on a row in a table
but I cannot group the data as it insists on showing all of the records in
the table even if only select the one field as if the *(select all) field is
there whether I like it or not.

Is there a way around this so I can group the data.

 

[Guest]

Can you post the SQL of the RowSource in the Combo?

 

[Guest]

SELECT MonthlyServiceReview.Month, * FROM MonthlyServiceReview WITH
OWNERACCESS OPTION;

Here the SQL the combo box generates.

 

[Guest]

The problem is with the * which mean select all

Try
SELECT Distinct MonthlyServiceReview.Month FROM MonthlyServiceReview WITH
OWNERACCESS OPTION

 

[Guest]

Worked a treat thanks. I need to learn SQL

The problem is with the * which mean select all

Try
SELECT Distinct MonthlyServiceReview.Month FROM MonthlyServiceReview WITH
OWNERACCESS OPTION