Cant set default value for value list combo box

[plantfinder]

I have a value list combo box called "Approved By:".

There are 3 values in the list, "Not Yet" is the first. I want not yet to be set as the default value. I've tried the following 2 solutions for the Default Value Property and neither seems to work:

[Approved By:].[ItemData](0)
=[Approved By:].[ItemData](0)

I thought one of these was correct. If anyone could help I would appreicate it.

Thanks

Mike

 

[TheAceMan1]

How are ya plantfinder . . .

In the [blue]Default Value[/blue] property of the combo enter [purple]"Not Yet"[/purple] ([blue]include the quotations[/blue]). Save, Close, then Open the form . . .

See Ya! . . . . . .

Be sure to see thread181-473997
Also faq181-2886

 

[plantfinder]

Thanks but that doesn't do it. No default value appears

 

[TheAceMan1]

Works for me in 2000 & 2003 . . .

See Ya! . . . . . .

Be sure to see thread181-473997
Also faq181-2886

 

[Remou]

You are referring to a bound combo? If so, default value is only relevant for new records. Do you want Not yet to be the value for any record that does not have a value?