control default value

[gator]

I have a combo box Row Source set as
SELECT DISTINCT FundDate FROM FundsAllYears ORDER BY FundDate DESC

How do i set the default value to be the latest date from the Row Source
above?

 

[Marshall Barton]

I have a combo box Row Source set as
SELECT DISTINCT FundDate FROM FundsAllYears ORDER BY FundDate DESC

How do i set the default value to be the latest date from the Row Source
above?

Since the row aource is sorted to put the latest date in the
first record, you can use:
[the combo box].ItemData(0)

 

[gator]

I get the message....
the method you tried to invoke on an object failed.
......but then seems to work? Is this OK?

I have a combo box Row Source set as
SELECT DISTINCT FundDate FROM FundsAllYears ORDER BY FundDate DESC

How do i set the default value to be the latest date from the Row Source
above?

Since the row aource is sorted to put the latest date in the
first record, you can use:
[the combo box].ItemData(0)

 

[Marshall Barton]

A failure message is never ok.

What, exactly did you do?

How did you figure out that the message came from the text
box's DefaultValue property? (Is that an exact copy of the
error message?)
--
Marsh
MVP [MS Access]

I get the message....
the method you tried to invoke on an object failed.
.....but then seems to work? Is this OK?

I have a combo box Row Source set as
SELECT DISTINCT FundDate FROM FundsAllYears ORDER BY FundDate DESC

How do i set the default value to be the latest date from the Row Source
above?

Since the row source is sorted to put the latest date in the
first record, you can use:
[the combo box].ItemData(0)