A
Alan T
My main form links to Invoice table:
ID
InvoiceNumber
Date
Sales
My subform links to InvoiceItem table:
ID
ItemNumber
Qty
Price
InvoiceID
These are Data tab of the sub-form:
Source Object: frmInvoice
Link Child Fields: InvoiceID
Link Master Fields: ID
Enabled: Yes
Locked: No
So on the main form whatever I navigator my invoices, the subform is always
empty.
ID
InvoiceNumber
Date
Sales
My subform links to InvoiceItem table:
ID
ItemNumber
Qty
Price
InvoiceID
These are Data tab of the sub-form:
Source Object: frmInvoice
Link Child Fields: InvoiceID
Link Master Fields: ID
Enabled: Yes
Locked: No
So on the main form whatever I navigator my invoices, the subform is always
empty.