Form calculation breaks on restart of Access 2007

M

morejunk

I'm pretty new to Access so maybe I'm just missing something (just
recently switched from Filemaker Pro).

I have two controls on a form (Names: "txtTotalEaten" and
"txtCalAllow"). I have a third control where the control source is
the expression below:

=[txtTotalEaten].[Value]-[txtCalAllow].[Value]

This worked until I shut down Access and relauched the app. I then
get a #Name error. Retype it. #Name

If I change the expression to:
=txtTotalEaten-txtCalAllow

Again. It works once. Shut down and relaunch... #Name.

I wish I could just call a value from a query but I can't seem to make
that happen either.


Very frustrating.


Thanks,
Adrian.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Repeated Requests for GSuite password when first Accessing Outlook 365 after system start 0
Referencing Subform Controls/Properties 2007 3
Shut down when saving a form 9
Calculating... 4
Calculating averages on a form 3
Access 2007 Switchboards 1
Calculating sales tax 8
Option Group, Unbound Form: 2467 Object closed or doesn't exist? 8

Top