Default Value in text box is not showing up!

[Guest]

Hi -- I have a text box (txtStatus) where I set the text box's Default Value
property to show "Not Yet Worked" in the text box as the default value. For
some reason, this value does not show up in the text box by default as I
intend for it to do.

The control source is the field Status in a table tblMissingCharges. The
text box control is not locked. I don't know what other property to
investigate to figure out why my text box is not showing the default value I
specifiy in its properties.

Any ideas???

 

[UpRider]

The default value will show only for *new* records. If your form is showing
an existing record, it will show what is in field Status of
tblMissingCharges, as that is the control source. If you want every record
in the table to show "Not yet Worked", there's no point in even having the
field in the table in the first place. Think about it.

UpRider

 

[Guest]

Thanks! They were not new records anymore by the time I added the default
value for the status text box.

The value will change later down the line, but always starts out as "Not Yet
Worked"