Show child records in tab controls

  • Thread starter Thread starter lassang01
  • Start date Start date
L

lassang01

Hi..

I am newbee to Ms Access and have a DB with:

tblsuppliers (supplierID, Suppliername address)
tblPurchaseOrders (PurchaseOrderID, supplierID, OrderText, Qty, Price)
tblInvoices has (InvoiceID, PurchaseOrderID, InvoiceVoucher)

I want to make a main form for tblPurchaseOrders that shows related
tblInvoices in tab controls ( this tab controls have limit according
to the number of invoices related to the PurchaseOrderID in main form)

I appreciate any help

Lassad
 
Create a form that displays the Invoices.

Open the form with the tab control.

Click on the tab you want to have the invoices show on.

Embed the first form as a sub-form on that tab.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Back
Top