Help!!- Subform Communication

B

bud2148

This is what I'm trying to do. I have a Customer table, supply table an
PO Table. I assigned the necessary "supplies" for each customer base
on the contract they signed.

Building a Purchase Order Module:

In the PO module, I have the Customer Info and in a subform1, I hav
the supplied template for that customer with a check box named "order"
Subform2, will consist of a list of the item(s) that we will ordere
based on what they select on subform1.

Question: How can I programmatically, tell Access to do the following:

1. When user selects "order" field in subform1, to transfer the suppl
information to subform2.

2. when user de-select the "Order" filed in subform2, to remove th
item from the list in subform2.


Thanks in advance for any assistance in this matter
 

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

Top