Why not create a Table with
StatusID (AutoNumber)
StatusName
StatusPercent
They you can do a DLOOKUP based on the chosen value, or better yet just join it in a Query.

Teri, you CAN have a field in a table change when another field is changed. This requires programming, such as an AfterUpdate event. It's much better to use a Calculated Query Field for this.

Let me try this, I have a table, it has all the fields I need. Based on that table I have a form, when the user enters the data in the form it updates the Table fields correctly. The next step I would like to achieve is in the form, when the user selects the status I would like the result to be... that the % complete field automatically updates. What I do not know how to do is build what I need to get that result. I built a query that gives a single result - Percent Complete: IIf([Status]="In Progress","25%"). I cannot figure how to write the statement for the multiple results and then how do I connect that to the form so that it will auto update the table. Maybe this is too much for me with the limited knowledge I have. I was trying to prevent data entry errors . I did not know if I could just build an event in the Form or what I needed to do to make sure that the information populated to my table. Right now it is manual entry in the form and table updates.

Richard, Once again you Made my day!!! It took me some time but it works!! I am learning More and More. Thank you so Much!! Both lessons Were great. As usual the error is between the keyboard and the Chair.

PBKAC Error?