-
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|