data in query but not in combo box

[icccapital]

I have a form that I added a combo box to based off of a table. After going
through the wizard I then entered the query of the row source and did group
by Invoice.InvDate in totals row of query. If I view the query that is
displayed everything works out, the invoice dates are shown with no
duplicates, but the combo box is empty when the form runs. Below is the sql
statement in the row source.

SELECT Invoice.InvDate FROM Invoice GROUP BY Invoice.InvDate;

What might I be doing wrong?

 

[fredg]

I have a form that I added a combo box to based off of a table. After going
through the wizard I then entered the query of the row source and did group
by Invoice.InvDate in totals row of query. If I view the query that is
displayed everything works out, the invoice dates are shown with no
duplicates, but the combo box is empty when the form runs. Below is the sql
statement in the row source.

SELECT Invoice.InvDate FROM Invoice GROUP BY Invoice.InvDate;

What might I be doing wrong?

Does this work any better?

Select Distinct Invoice.InvDate From Invoice Order by Invoice.InvDate;

Also Check....
Column count property = 1
Bound Column = 1
Column Width property "1"

 

[icccapital]

Great, I don't think the new select statement worked, since it didn't show up
after I did that. But had to set Column count to 1 from 2 and set column
width from 0";1" to "1", and it seems to be working. Thank you