Sample data · this browser only

Assets

Canonical tblAssets. Category and condition combos store CategoryID / ConditionID and show the name. Mark Retired sets Active = No and RetiredDate. Leaving a dirty record asks Do you want to save changes? (Yes / No / Cancel) — Access Me.Dirty.

localStorage · What this demo shows · Students · Demos

Active assets (Split · datasheet)

Click a row. List column is the joined category name; the form combo stores the ID.

ID AssetName Category Location

Asset

AssetName, Category, and Condition required. Mark Retired hides the row from the active list.

What this demo shows

A Microsoft Access asset register in the browser: the same table names, the same IDs in combo boxes, and the same save-changes question a bound form would ask.

  • Split form — datasheet on the left, current record on the right (frmAssetList / frmAsset).
  • Combo stores the ID — Category and Condition save CategoryID / ConditionID and show the name. No extra query just to display the text.
  • Mark Retired — sets Active = No and RetiredDate without deleting the row.
  • Unsaved changes — leave a dirty record and you get Yes / No / Cancel, like Access Me.Dirty. Yes saves, No discards, Cancel stays put.

Will this work when the data is in a database?

Yes. The prompt is form behaviour, not a storage trick. This public page saves sample rows in this browser (localStorage). When the same page writes to a company database, Yes still means save this record, then move. The only extra is a network save that can fail — if it fails, you stay on the record, same as a validation error.

Sample data only. Source: Microsoft Access Assets template.