Formula keeps disapearing

[tgambill]

I created a form which includes 2 fields with numbers in them and one box which does a subtraction of those 2 numbers. Specifically, "desired inventory" and "current inventory" and then "number to order" with the expression "=[Desired Inventory]-[Current Inventory]" in the control source box of the property sheet. My issue is that every time I open the database, I get the expression "?Name" in the "number to order" field.



Here's the kicker...if I pull another "number to order" field into the form in an open area and mark it no for visibility, the formula works and comes up as the correct subtraction number in the original "number to order" field. The next time I open the form, I get the same error until I delete the second "number to order" field and then put it in again even though I saved the table during my last session.

I hope this makes sense. If anyone has any suggestions, I would appreciate your help. Thank you.

[RuralGuy]

It sounds like a timing issue. Why not put the calculation in the RecordSource query then bind your "Number to Order" control to the answer. That is where I put most of my calculations.

[tgambill]

Forgive me but I'm new to creating forms on Access. Please tell me how to put the calculation in the Record Source query then bind it to the "Number to Order" control. If you are talking about using the Record Source on the Property Sheet, I tried that. I have 29 fields on the form and it only gives me 10 fields on the query. The fields I don't put into the query come up with ?Name.
I created a query based upon the original table with the calculation in the "Number to Order" field which works, but Access will not allow me to pull any fields from a query, only from tables.

[June7]

Calculated fields can be referenced in textbox ControlSource.

If you want to provide db for analysis, follow instructions at bottom of my post.

[RuralGuy]

Assuming your calculated query has been save, remove the RecordSource of the form and save the form. Then open the form again in design mode and set the RecordSource to the query again. You should now be able to see *all* of the fields in your query including your calculated one.

[Rainlover]

There is something wrong with your query.

You should be able to open the query and see all the fields that you are talking about.

If not then reconstruct your query.

[tgambill]

Here is the db

[RuralGuy]

Both your "Main" and "Number to Order" forms work as expected and update the "Number to Order" controls.

[tgambill]

If they are both working properly, why am I still getting the errors on the "Main" form for the "Number Needed" field?

[RuralGuy]

Hmm...I have ac2013 loaded right now. Let me load ac2010 and see if there is any difference.

[RuralGuy]

Same result with ac2010. What are the specs on your PC? Speed, Ram etc.

[tgambill]

2.5 GHz processor, 2.00 GB RAM, 32 bit Operating system

[RuralGuy]

2.67 GHz i7 920, 11GB Ram, 64 bit Win7
What processor are you using? Even though it runs, I think Win7 likes more than 2GB Ram (at least 3).

[RuralGuy]

Does your "Number to Order" form work properly?

[tgambill]

2.5 GHz processor, 2.00 GB RAM, 32 bit Operating system

Here is what the system tells me.