Main and Sub Forms repost

[HubbyMax]

I have designed a main form using a sub form that allows me to enter the
different items. Now my problem is that when I do enter new items in the sub
form they are not saved to the table including the info on the main form. The
main form and the sub form are joined on the requisition number. Example:

The Main form collects all information on the requester, Sub form collects
the
information on what that requester orders. Main form info is saved and
contains the Requisition number. The sub form "Requisition number" field
updates to the Req number on main form and I enter the items requested. The
Table these forms use ends up with 1 entry for info contained on the main
form and 2 or 3 entries containing the items they want along with a bland
record or two that just shows the requisition number. All these entries
contain the Req.
number but I want the entries for the items to include the Main form info
along with the sub form info not have the main form info as a seperate record.

 

[HubbyMax]

I also want to be able to go back and see what and who ordered on a request.
As it is now, several records are created with the same requisition number,
one with main form info, one for each item listed on the sub form, one with
just the requsition number, etc. When I try to go back and look at completed
Requsition numbers I have to page thru several records that contain that
requsition number.

 

[Jeff Boyce]

You are describing forms ...

In Access, it all starts with the data. How depends on what.

Please describe your underlying data (tables, fields)...

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or psuedocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.