Getting myself in a bit of a mess here and hope someone can help
the form FrmTierEntry should list pupils names with an empty Tiertaken which it gets from another table as part of the form query
Id like that to be filled by default with a tier which is linked to another field (defaultTier)
Pressing a command button (I hope) will then allow my staff to alter the TierTaken field.
But I cannot seem to find any solution. And the more I look at it, the more I get lost. Hope someone will look with a fresh pair of eyes and get me back on track
Andy
DBschoolexamPapersvtest.zip