CODEWITHSUNDEEP
sqlms-accesscombobox
Best
Best

Reputation: 2318

Set Row Source property to SQL statement in Microsoft Access

I tried to set the following SQL statement into Row Source property in Access but the statement did not seem to be executed:

 SELECT DISTINCT ProjectName FROM tblProjects ORDER BY ProjectName.

Does it mean that I got the syntax wrong?

Upvotes: 0

Views: 1368

Answers (1)

Olivier Jacot-Descombes
Olivier Jacot-Descombes

Reputation: 112324

If the SQL was wrong, you would get an error when opening the ComboBox. Are there projects with a non-empty ProjectName in the table? Also check the ComboBox properties ColumnCount, ColumnWith, ListRows. The RowSourceType must be set to Table/Query!

Upvotes: 1

Related Questions