Sub Form Locking Problem

[Guest]

Hi,

i have a problem with a subform. it is a part of my database quote form and
i am currently able to add materials, then add extra text to the end of the
detail along with having the ability to manually change the amount of items
required in the quantity box. on top of this, i have a tick box which gives
me the choice to have the items on or off the quote report. my problem is, it
seems to have locked. i cannot select a tick box, i cannot alter any
quantities or text. i just seem to be locked out.
i have looked in the properties but everything seems to be right.

anybody have any ideas?



Regards,

Nigel

 

[Guest]

Hi Nigel,
To get this straight in my mind, You can -
Add and Edit the main form
Add multiple records to the subform
Cannot go back to edit a subform record that you have moved away from?

Nick

 

[Guest]

Hi,

i COULD go back and change the data but now i can't. i have since realised
that it only happens when i update the Qry that the form gets its info from.
i have lots of fields in the Qry but i am using 2 in particular. Extended &
Cost. it locks up when i add an extra column "ActualCostSum" which sums the
Cost*Quantity. The sum is correct because i get the correct information but
it locks up. to add to this, if i remove the addd column, it still locks up!!

regards,


Nigel

 

[Guest]

I would say the most probable cause is that the query is not updateable
because it draws from more than one table or due to its calculated fields.
Do the calculations need to be done in the query? What about basing the
subform on a table and using an append statement to write the new data to the
tables? The calculated fields from the query might be done of the form itself.