Sample data · this browser only

Students

Canonical tblStudents / frmStudentList (Split). Level is a lookup (tlkpStudentLevel): the list shows the name, the form stores LevelID in a combo. Data lives in this browser only.

Active = still on the register · What this demo shows · Events · Demos

Active students (Split · datasheet)

Click a row to load the selected record. The Level column is the joined name, like Access qselStudentsActive.

ID LastName FirstName Level Room

Student

FirstName, LastName, and Level are required. Mark Inactive sets Active = No.

What this demo shows

A Microsoft Access student register in the browser. The combo stores the level ID; the list shows the joined name.

  • Split form — list plus current record (frmStudentList / frmStudent).
  • Combo stores the ID — cboLevel saves LevelID, shows LevelName. High ROI: no extra query just to display the text.
  • Mark Inactive — Active = No without deleting the row.
  • 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. Combos, filters, and save are form behaviour. This public page keeps sample rows in this browser. The same field names work when save writes to a company database.

Sample data only. Source: Microsoft Access Students template.