Form based on Calculated Query

  • Thread starter Thread starter John Stewart
  • Start date Start date
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
 
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.
 
Back
Top