Eliminating unwanted form data

[Uncle Gizmo]

the table design is almost certainly not normalised, as it appears to have 14 fields for the possible subjects.

If Minty is right, then you should find my blog useful:-

Excel in Access - Nifty Access

Excel in Access - Problem & Solution! One of the most frequent problems I see is people confusing MS Access with Microsoft Excel. This leads to fundamental design errors. Now, the problem is, this error "A Major Error" does not become apparent straight away. Unfortunately your database will work...

www.niftyaccess.com