saving default value to field problem

[sk88]

I have a List box set to YES and default value set to YES.


I would like to hide this field and when I click SAVE in my form, I would like to save it to my table.
I did set the control source to the field that I want but somehow it is not working unless if I click on to YES then save.

How do I set it in such a way which will save even without me clicking on to the LIST BOX?

in other words.. basically I want the default value to be saved when I click SAVE command button.

Thanks

[June7]

One way is to set the field's default property in the table.

[sk88]

That works but only for one form.

My table is actually linked to 2 different forms. If I default the field's value in the table, it forces the value even when I don't need it.

Is there a way that when I Hit save in the form, then only the value will be saved?

[June7]

Assuming the field is part of the form's RecordSource, in some event populate the field with: Me!fieldname = vbTrue

Must use -1 or 0 as value in Default property for Yes/No field.