Hermhart, I dun seem to understand the advice.

The control source property. Do u mean I need to create a form first for the field? I always thought that a table must be created first before a query or a form. So if the table field's properties does not allow me to use formula in the fields, how can I create the form.

Unless u r getting at creating a Null Field in the Table first where after designing the required form, the table will show the values I want in the required fields.

Next, the closed orders. As mentioned, the closed orders are determined by running a unmatched query. The results from the query are the closed status. Nope, I do not require manual input to closed the orders.

So from the results of the query (that's the criteria - no match from my Orders Table and my Generated Table), how do I formulate for the Status Field in my Orders Table to be stated as Closed.

Well, to be frank, I'm lousy with Access, least to say coding.

But I really appreciate your great help.

At least I am heading somewhere with my database now. Thanks.