Sample data · this browser only
Lookup combo + Edit
Canonical tlkpInfo / frmDemoItem.
Each drop-down stores an ID and shows the name.
Edit opens that list only (Access frmTlkpInfo).
Tick Hide Me to take a value out of the drop-down without deleting it.
Click a row to load the selected record.
| ID | Title | Status | Assigned |
|---|
Sample item
Lookups store the ID and show the name. Edit is the Access pop-up.
What this demo shows
One Microsoft Access lookup table, several lists. The combo stores the ID; Edit maintains that list only.
- One table, many lists —
tlkpInfogrouped (status, category, assigned). - Combo stores the ID — the control shows the name, the row keeps the key.
- Hide Me — drop the value from the combo without deleting the ID, so old records still resolve.
- Edit dialog — add or unhide values; the combo refreshes, like a requery in Access.
- Unsaved changes — leave a dirty record 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. The same tlkpInfo shape is what we would save in a company database.
Sample data only. Not a live production system.