Is the form bound to tblStats? If so, bind the combo box to the Status field.


On the combo box Property Sheet you could make the combo box Row Source a
Value List, then for the Row Source enter:
Complete;Incomplete;Pending

The combo box Bound Column and Column Count are both 1.

Not sure why you specify typing a value into a combo box. You can do that,
but typically the idea with a combo box is that you select a value. If Auto
Expand is set to Yes you should be able to start typing, and a word will
appear when what you have typed matches an entry on the list. In this case,
typing "C" should display the word "Complete", after which you can press Tab
or Enter, or click elsewhere on the form.

I don't have Access 2007 in front of me, but I believe the procedure is at
least similar to what I have written here.

Mort wrote:
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

--
Message posted via http://www.accessmonster.com