I am designing my second database, Access 2007.
I need a drop-down list on a form which enters data into the table tblStats.
I want a combo box and will type in three values,
Complete;Incomplete;Pending. When one of these values is selected for the
active record, that value should go to the field Status in the table tblStats.
I can not figure out how to accomplish this. Please help

Mortimer