If those are fields in the form RecordSource then they are also in the RecordsetClone, so try:
.tcost = (.Style_Pr + .Increase_Cost + .Price_rng_pr) * DSum("Qty", "Screen_size", "screen_detail_id=" & [screendetailsubform].Form!Screen_detail_id)
VIP
Windows 7 64bit 
Access 2010 32bit
If those are fields in the form RecordSource then they are also in the RecordsetClone, so try:
.tcost = (.Style_Pr + .Increase_Cost + .Price_rng_pr) * DSum("Qty", "Screen_size", "screen_detail_id=" & [screendetailsubform].Form!Screen_detail_id)
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
update field in existing records displayed in subform from main form autonumber
Coded Loop v SQL Update Query Performance
Loop through subform records
Posting Permissions
Reply With Quote