can't get default value to show

[blueman]

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

 

[boblarson]

Are you doing this on a form or a table? If your combo is in the table
(lookup field) then get rid of the lookup fields at table level (see here for
why: http://www.mvps.org/access/lookupfields.htm)

If on a form then you can't set the default to a control that might not have
a selection yet. Use code to populate the text box in the after update event
of the combo box.
--
Bob Larson
Access World Forums Administrator

Tutorials at http://www.btabdevelopment.com

__________________________________

 

[John Spencer]

Well, that control name may have to be referred to using the following name.
Approved_By_

It is a very good idea to avoid the use of any characters that are not
letters, numbers, or the underscore in your control names.
I would try the following

=Approved_By_.[ItemData](0)

Or just

="Not Yet"



John Spencer
Access MVP 2002-2005, 2007-2008
Center for Health Program Development and Management
University of Maryland Baltimore County