Please Need Help on this Loop Statement

N

Ned

I have 2 Subforms, both linked to each other on a main form. SUBFORM1
is a summary form on Orders placed with Suppliers and SUBFORM2 is the
detail for each order placed in SUBFORM1.

SUBFORM1 recordsource is a Table TBL_ORDERMASTER with fields and data
type as follows: ORDERNO (Text), ORDERDATE (Date), TAXSTATUS (Checkbox-
Yes/No), GROSSAMT (Number-Double), TAX (Number-Double) and NETAMT
(Number-Double).

SUBFORM2 recordsource is a Table TBL_ORDERDETAILS with fields and data
types as follows: ORDERNO (Text), ITEMNO (Text), QTY (Number-Integer),
RATE (Number-Double), GROSSAMT (Number-Double), TAX (Number-Double)
and NETAMT (Number-Double).

WHAT NEEDS TO HAPPEN (I need help on the loop statement
below)...........

When the TAXSTATUS in SUBFORM1 is set to YES, (I have done this
part..., besides the TAX in SUBFORM1 being automatically calculated),
NEED HELP FROM HERE FORWARD >>>, the TAX for all records in SUBFORM2
should also automatically calculate for the particular record in
SUBFORM1. If the TAXSTATUS is set to NO, then the TAX for all records
in SUBFORM2 for the particular record in SUBFORM1 should be set to
zero automatically.

Hope I have been able to clearly illustrate the issue above. Thanks
in advance. Ed
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Linking subforms - 5
Display 0 in a textbox that obtains a null value from a subform 6
Subform1 disappears when tab to subform2 0
Change Subform based on record selection 4
Syntax for Refreshing Control on Sub-Subform 6
Prevent auto-load record on subfrom under certain condition? 1
Update a table on second subform 0
Changing the active record on a form, via code on a different form 9

Top