Mort,
A combo control (like a text control) can be "bound"
to a field in the table/query behind the form. Which means that any
value entered into that control, when updated, will be written to that
field in the table. Fields that are bound to the control are indicated in
the control's ControlSource property.
From what you've desciribed, you should be able to
"bind" the combo control to the Status field in tblStats.
Make sure Status is included in the query behind the form, and enter
Status
in the ControlSource for your combo.

Set your combo's RowSourceType to Value List
Enter "Complete"; "Incomplete"; "Pending" into the combo's RowSource
--
hth
Al Campagna
Microsoft Access MVP 2007-2009
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."

"Mort" wrote in message
news
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