Show child records in tab controls

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
 
J

Jeff Boyce

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
 

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

Updating calculated field in table without tabbing out of record. 1
Inserting a record is generating an error 5
Subform does not show details records 2
Can't select row in listbox on tab control page 2
Display Child Records in subform 7
tab controls 4
Tab Controls 3
Multi page tab 3

Top