Default Value Problem

[TheHarleygirl2005]

I have a field called "CompanyName". This field uses a value list created in the table with unique items I typed in myself. When I open the form, I would like the default value for that field to be the first item in the list. I added the following code to the default value box on the data tab in the form:

=[CompanyName].[ItemData](0)




Nothing happens, the field still shows blank when opening the form. Any idea what I'm doing wrong?

[TheHarleygirl2005]

Cancel this. It actually did work, it just didn't update my current entries. It will default to my first item on a new entry. Is there a way to update all my current listings other than manually? This is a new field so I have almost 300 entries that need to be updated.

[pbaldy]

An update query if you know the value:

UPDATE TableName
SET FieldName = 123
WHERE FieldName Is Null