Continuous subForms problem

[fule12]

Hi,

I have Form and Continuous subForms.Link is OrderID.
on Main form i have field Estimate cost.
in subform i enter invoice cost and invoice Number
So for each order i have 1 est.Cost and i can have 3-4 invoice Cost.In footer of subform is Sum(InvCost).On main form is unbound field (amount = Est.Cost - sum(inv.Cost)).
Every month we run report for Accrals order.
So let say on 01/31/02 report was like this :

orderNo Est.cost
12 500 $
13 300 $
14 1500 $ ect...ect...
On 02/15/02 i receive invoice for order 14 - 300$ and on
02/23/02 i receive another 1000 $ for same order.Now my report for 02/28/02 look like this :

order No Est.cost
12 500$
13 300$
14 200$
But for order 14 i will not receive another invoice.Reasons can be different(price of part go down, discount, different in currency ect..ect)
So i come on idea to create check box in invoice Subform.
I call him last invoice. So let say i enter firs invoice(order 14 - 300 $)than i add another one (order 14 - 1000$)
so is possible that check box on first one to came invisible or locks. And if i seleck chbox on second invoice Order will be close so on my report OrderNo 14 will not show.

Thanks in advance

Fule

 

[Haitham]

Dear Fule

As i understood, ur customer paying u in a deposits not full amount, so in this case..........
* u have to add field such a yes/no and call it "Paid".
* u have to have a table for collecting the credit invoice when ever customer paying untill invoice will close to 0.
* u have to create ur report from query which suming all the amounts for each and every Invoice.

For Example:

Invoice # 555 Amount Is 2500$

on 1/1/2003 Paid 1000$ <<<< Paid Is False
on 5/2/2003 Paid 500 $ <<<< Paid Is False
on 1/3/2002 Paid 1000$ <<<< Paid Is True

Hope That Helps,

If Not Then
U Can Send Me Ur DB By E-mail
Else
Good Luck
End If

Haitham

 

[fule12]

hi, Haitham
Yes this is what i need.I have table InvOrder where is all invoice and i create field yes/no - is check box on subform.
But how to control check box.What i have in head is this:
In main form I enter Estimate cost.In Subform i have field
Inv.Cost ,invNo and checkBox -Last invoice.so if I enter 2 invoice , on first one checkbox will be unvisible and on second one visible.So just on last invoice check box need to be visible.

Thanks Fule

 

[Haitham]

Hi fule12,

Sorry, i did not understand from ur last post the way as i explain to u is:

the Paid field should be in a main form.....
so when u do recipt for the new deposit if the amount is 0 then the checkbox &quot;Paid&quot; will set to True........ so the report will be like this......
Main Form + Sum of all deposit's and Paid = false.

I hope u understand, if not please let me help u by sending me ur DB in Zip File and i'll try to make it 4 u.

Saam001@yahoo.com

Good Luck