calculated fields on a form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am writing a form to display and edit order lines. Next to the fields that
can be edited, I want to display a calculated field, which is worked out from
a costs table. But if I put the calculation into the bound query, I cannot
edit the rest of the fields.
Also, due to the number of orderlines displayed, I do not have space for a
subform to get the calculation from.

Changing the ControlSource to point to the calculated query just returns a
#name? error.

Can anyone please show me how I can make the the records on the form
editable, and still display the calculation
 
Vanessa,

It is likely that you could put your calculation expression into the
Control Source of the textbox, and if this isn't working for you, it
could be that you are just using incorrect syntax or something (sorry, I
can't be more precise without some more details from you!) One thing to
check is that the name of the textbox is not the same as the name of a
field in the query.

There are probably also ways to include the calculation in the query
that the form is based on, without the query being non-updateable as a
result. Maybe you could post the SQL of the query you tried so far, it
might help to know what you are doing.
 

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

Form calculations on imported data 2
Calculating averages on a form 3
Calculated field in a table 6
Automatic updating of a field 5
How to calculate form field 1
Form Calculations 2
Display 0 in a textbox that obtains a null value from a subform 6
Populating a field in a table from an unbound field in a form. 5

Back
Top