Calculated field on subform problem

[crich21]

Calculated field on subform problem

I have a frmOrdersSubform which I use to enter order details ex.
order date
ship date
productid

currently the form uses a sql string as a recordsource.

I calculate the 'amount due' in qryamountdue however I can't seem to be able to add this field to my subform and still make it updateable.

any suggestions would be excellent.

oh I also tried calculating the 'amount due' in the forms sql string also and it makes the recordset not updateable also

thank you in advance

 

[Nouba]

Have you tried doing your calculation in an unbound text control? If your calculation depends on more than one record, place the text control in the footer section.

If this doesn't help, you can show us at least your query with the calculations and maybe some sample data.

 

[crich21]

Here is my sample

I have tried everything I know, which isn't much. I understand what you are asking and yes I tried doing the calculation in the defaultvalue and the controlsource but don't know if i did it right so it may work I don't know. I have posted my db for you to check out if you could. I really wanted to use the sample orders db that access 2k offers but could not convince my brother that he needed the extra forms for order entry. Thankyou Nouba