Autopopulate Form

[mous]

Hi, Sorry to post a similar question that I've read in the forum but I can't seem to get the answer I want.

I have a form consisting of one table (Access 97). One field in this table has a field named StuReqd.

After the user has filtered their records, I would like the user to press a button (Mark Filtered Records) for example. And then for Access to mark each student with a Y in the StuReqd field.

I have found the code in another posting of:

Private Sub stureqd_AfterUpdate()
Me![StuReqd].Tag = Me![StuReqd].Value
End Sub

Private Sub stureqd_Enter()
If Not (IsNull(Me![StuReqd].Tag) Or Me![StuReqd].Tag = "") Then
Me![StuReqd].Value = Me![StuReqd].Tag
End If
End Sub

Which is OK if I place a Y in the first student field and then click in each of the other StuReqd fields. I could have 300 students - I don't want to do this myself this defeats the object of autopoulate.

Any suggestions would be gratefully received?

Many Thanks

Dawn