Access → Web

Master–detail live demo

Online recreation of an Access laboratory sample — tables LabParents / LabChildren, parent form frmLabParent with subform subChildren (LinkMasterFields=Id, LinkChildFields=ParentId).

Source: Access SaveAsText lab · Browser storage only · What this demo shows · LabItems · TaskList + VBA · Canonical Issues · Demos

Parents (frmLabParent)

Select a parent — children filter like an Access subform (Id → ParentId).

Id Parent name Children Actions

New parent

Children (subform)

Select a parent to show linked LabChildren rows.

Id Child name Qty Actions

Child (subform row)

What this demo shows

An Access parent form with a linked subform: LabParents / LabChildren, LinkMasterFields=Id, LinkChildFields=ParentId.

  • Subform filter — children belong to the selected parent.
  • Unsaved changes — leave a dirty parent or child and you get Yes / No / Cancel (Access Me.Dirty).

Will this work when the data is in a database?

Yes. This page uses sample rows in this browser. Yes writes both the parent and the child if both have values, then moves.

Sample data only. Not a live production system.