I have a From ComboBox and a To ComboBox on a Form; cboFrom and cboTo. The
Row Source is this:
SELECT DISTINCT SharePrices.DateTime FROM SharePrices ORDER BY
SharePrices.DateTime;

The SQL is this:
SELECT DISTINCT SharePrices.DateTime
FROM SharePrices
ORDER BY SharePrices.DateTime;

Nothing is showing in either ComboBox; all I see is a whole bunch of blanks.
I just did this in another form in another Access database. I can’t figure
out why it’s not working for me now. I’m using Access 2007.

I’d sincerely appreciate any insight with this.

Thanks!
Ryan


--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.

Hi ryguy7272,

in the properties of your combos check the column count that must be at
least 1 and the column widths that must be <>0.

HTH Paolo

"ryguy7272" wrote:

> I have a From ComboBox and a To ComboBox on a Form; cboFrom and cboTo. The
> Row Source is this:
> SELECT DISTINCT SharePrices.DateTime FROM SharePrices ORDER BY
> SharePrices.DateTime;
>
> The SQL is this:
> SELECT DISTINCT SharePrices.DateTime
> FROM SharePrices
> ORDER BY SharePrices.DateTime;
>
> Nothing is showing in either ComboBox; all I see is a whole bunch of blanks.
> I just did this in another form in another Access database. I can’t figure
> out why it’s not working for me now. I’m using Access 2007.
>
> I’d sincerely appreciate any insight with this.
>
> Thanks!
> Ryan
>
>
> --
> Ryan---
> If this information was helpful, please indicate this by clicking ''Yes''.

Ah! That was it! My Column Count was set ti 1, which was fine, but my
Column Widths were 0";1", which was not right. I changed Column Widths to
1", and it works fine now. Thanks so much!!
Ryan--

--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"Paolo" wrote:

> Hi ryguy7272,
>
> in the properties of your combos check the column count that must be at
> least 1 and the column widths that must be <>0.
>
> HTH Paolo
>
> "ryguy7272" wrote:
>
> > I have a From ComboBox and a To ComboBox on a Form; cboFrom and cboTo. The
> > Row Source is this:
> > SELECT DISTINCT SharePrices.DateTime FROM SharePrices ORDER BY
> > SharePrices.DateTime;
> >
> > The SQL is this:
> > SELECT DISTINCT SharePrices.DateTime
> > FROM SharePrices
> > ORDER BY SharePrices.DateTime;
> >
> > Nothing is showing in either ComboBox; all I see is a whole bunch of blanks.
> > I just did this in another form in another Access database. I can’t figure
> > out why it’s not working for me now. I’m using Access 2007.
> >
> > I’d sincerely appreciate any insight with this.
> >
> > Thanks!
> > Ryan
> >
> >
> > --
> > Ryan---
> > If this information was helpful, please indicate this by clicking ''Yes''.