Form based on Calculated Query

J

John Stewart

I'm having trouble with a form based on a query that has
two calculations in it. With calculations in the query,
the form refuses to show all of a memo field and won't
allow edits in any field. If I remove the calculations, it
works. Anyone had this trouble??? Thanks, jjs
 
W

Wayne Morgan

I don't know why the memo field is doing that, unless it is in one of the calculations.
However, a query with calculations in it is not going to be an updatable query, which is
why you can't do any edits. You will need to pass the data to the form using an updatable
query and do the calculations on the form.
 

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

Split form 0
Trying to create a report that will list unmatched records by Ticket Primary Key 0
Display weeks from a Milestone 0
requerying a main form calculated fields from after subform data entry 7
DLookup in Continuous form 0
Using DSUM to get running total on a filtered form 0
Rounding decimal values in forms and reports 2
blank form, can't insert new record 11

Top