Sub Form

[Edgar Thoemmes]

StatusID(FK to Tbl_Status)

I have a Tab Control form with two tabs: Supplier Details and Contracts. On
the contracts form I have added a sub-form which displays the contract
description. This is displayed in a text box and the user can tab through the
available records.

What I would like is for all contracts to be displayed in a list box and
then to nest another sub form at the bottom that would display the details
for the contract, which the user selects from the list box.

This is thoroughly confusing me – I can get the list box to display all
Contracts but I cant seem to restrict it to the contracts for the related
supplier on the first tab.

Also I don’t really know how to nest the 2nd sub-form, which form do I nest
it in – the Tab Control form or the original sub form?

Related tables:
tbl_Contracts – ContractID(PK), SupplierID(FK to tbl_Suppliers),
ContractDescription, StartDate, EndDate, OwnerID(FK to tbl_Owners),
EntityID(FK to tbl_Entity)

tbl_Suppliers – SupplierID(PK), SupplierName, Address, City, Notes,



Thanks for your time.